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 |
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to jion 2 tables, without using any condition?
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.
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?
How to convert multiple rows to single row (multiple columns) in informatica
what is the flow?
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 .
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to add source flat file header into target file?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
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