1 lac of flat fles in source how to load target at a time?

Answer Posted / anoymous

This can be done by File list or File repository. Create
rep.txt file list in that write all the paths of the i lac
flat files.
in session level set the following attributes
source file name indirect
source file directory filelist path address
source file name rep.txt

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between source qualifier and filter transformation?

1118


How to create the source and target database connections in server manager?

710


What do you understand by term role-playing dimension?

686


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1777


Is stop and abort are same in informatica?

657






What are the mapping parameters and mapping variables?

716


What is an unconnected transformation?

764


What is data movement mode in Informatica and difference between them?

722


How to extract sap data using informatica? What is abap? What are idocs?

676


I have a flat file, want to reverse the contents of the flat file

789


What is update strategy transform?

696


Explain the different dimensions.

650


What is meant by query override?

738


How do you load first and last records into target table?

784


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1904