1 lac of flat fles in source how to load target at a time?
- 4 Answers
- 10259 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What are the differences between joiner transformation and source qualifier transformation?
what are the output files that the informatica server creats during running a session?
which transformation uses cache?
How does the session recovery work.
How to eliminate 1st and last rows from the source and load the inbetween rows.
what are the deliverables?in your project?
What is a snowflake schema?
how can one come to know wether the records loak into the target if we use update strategy
How many numbers of sessions can one group in batches?
which is better perfomancewise lookup or joiner and why?can anyone give example?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
Teradata 
