How to convert IBM Cognos generated XML to a readable XML format for ETL tools



How to convert IBM Cognos generated XML to a readable XML format for ETL tools..

Answer / ravi

https://etltechsolutions.wordpress.com/2017/03/31/unix-generic-xslt-normalization-for-table-data/

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  


What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,


I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,






in static and dynamic which one is better

2 Answers  


What are the mapings that we use for slowly changing dimension table?

2 Answers  


wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,


define galaxy repository in informatica

0 Answers  


if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,


What is update strategy transform?

0 Answers  


What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  


Categories