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

if we have a delimiters at unwanted places in a flat file how can we over come those.

1797


How we can create indexes after completing the load process?

910


Explain constraint based loading in informatica

827


What is aggregator transformation in informatica?

729


Name at least 5 different types of transformations used in mapping design and state the use of each.?

888


Please let me know how to make Data masking in informatica..

1460


What is lookup change?

808


What are the databases that informatica can connect to windows?

788


What is a filter transformation?

798


Mention few advantages of router transformation over filter transformation.

833


What is informatica metadata and where is it stored?

760


Parameter and variable differences

1824


What is the reusable transformation?

826


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1778


What you know about transaction control transformation?

745