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 |
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
What are the session parameters?
Sequence generator, when you move from develoment to production how will you reset
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
What are the types of metadata that stores in repository?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
If informatica has its scheduler why using third party scheduler?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
in which situations do u go for starflake schema ?