1 lac of flat fles in source how to load target at a time?
Answers were Sorted based on User's Feedback
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 |
Answer / mike
@ above answer
well its source filetype which need to be indirect
Is This Answer Correct ? | 2 Yes | 0 No |
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 |
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 |
Explain sessions. Explain how batches are used to combine executions?
How an expression transformation differs from aggregator transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
without using rank transformation how can we rank items by using some other transformations
how to identify new and old values in source qualifier or any other transformations using informatica
Please let me know how to make encryption and decryption with example?
tell me 5 session failure in real time how can you solve that in your project?
can we use bulk loading when we use look in mapping
Difference Between ETL & ELT?
Which transformation should we use to normalise the COBOL and relational sources?
How can u work with remote database in informatica?did you work directly by using remote connections?
how can u approach u r client