Informatica scenario based question - IICS row to column conversion || Informatica cloud

[@anudipray4492]

Why you have not use list agg for comma separated values

[@harishukkisala280]

Write a oracle sql query SRC 1 1,2 1,2,3 OUTPUT 1 1 2 1 2 3 Write a query to show the output in following manner and informatics also FIELD1 , FIELD2 A , 10 A , 20 A , NULL B , NULL B , 10 C , 10 C , 20 OUTPUT FIELD1 , FIELD2 A , 10 B , NULL C , 10 IN ORACLE SQL