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

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,


How to jion 2 tables, without using any condition?

11 Answers   Amazon,


Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  


How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,


What is domain in terms of informatica?

0 Answers  






How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,


what is the flow?

1 Answers  


I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,


How to add source flat file header into target file?

3 Answers   Logica CMG,


HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,


I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


Categories