In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation.
If millions of files are there, how can we enter the flat file names in list file?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
what transformations are used for Variable port?
how to identify new and old values in source qualifier or any other transformations using informatica
Explain sessions and how many types of sessions are there?
Why use the lookup transformation ?
scenario where i can use only concurrent execution of workflow.
what is scd?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
How to generate sequence numbers using expression transformation?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,