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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / mike

@ above answer
well its source filetype which need to be indirect

Is This Answer Correct ?    2 Yes 0 No

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

Answer / usha

By using list file concept we can process 1lac files.
list of files should have same struture.
then only we can process all file.another importent thing
we should set source file type as indirect

in session level set the following attributes
source file type indirect
source file directory filelist path address
source file name file_s.lsh

Is This Answer Correct ?    1 Yes 0 No

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

Answer / manojkumar

I think Source file name should end with .lst extension
like "filename.lst"

And this list file shoud include all 1Lac file names.
Remaining all same as above only.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

Explain sessions. Explain how batches are used to combine executions?

0 Answers  


How an expression transformation differs from aggregator transformation?

0 Answers  


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


without using rank transformation how can we rank items by using some other transformations

2 Answers  


how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  






Please let me know how to make encryption and decryption with example?

0 Answers  


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


can we use bulk loading when we use look in mapping

1 Answers   TCS,


Difference Between ETL & ELT?

1 Answers   TCS,


Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,


How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  


how can u approach u r client

2 Answers   CTS,


Categories