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?
Post New Answer View All Answers
Explain pushdown optimization and types in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is DR strategy for Informatica project?
What is resilience time?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What does refresh system mean, and what are its distinctive choice?
How many input parameters can exist in an unconnected lookup?
What is the difference between a repository server and a powerhouse?
Explain about Informatica server process that how it works relates to mapping variables?
What are the different types of transformation available in informatica.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what are factless facts? And in which scenario will you use such kinds of fact tables.
can you please explain me pre session and post session options?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
In how many ways we can create ports?