How to create the list file having millions of flat files while indirect loading in informatica?
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?
No Answer is Posted For this Question
Be the First to Post Answer
Is it possible to use a client with different version than that of its Informatica server?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
what is the incremental agrrigation?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
how will compare two mappings in two different repository?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist few areas or real-time situations where informatica is required.
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?