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 |
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
What are the settings that you use to configure the joiner transformation?
To import the flat file definition into the designer where should the flat file be placed?
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??
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
in static and dynamic which one is better
What are the mapings that we use for slowly changing dimension table?
wt is Dynamic lookup Transformation? when we use?how we use?
define galaxy repository in informatica
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
What is update strategy transform?
What is the Difference between SetVariable and setmaxvariable in informatica?