Interested to Buy Any Domain ? << Click Here >> for more details...
1 lac of flat fles in source how to load target at a time?
- 4 Answers
- 11827 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 |
i have 2 session s1 execute s2 load first session fail what is the reason?
how can we load starting with 11th record of a table from source to target
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to create a non-reusable instance of reusable transformations?
can we override a native sql query within informatica? Where do we do it?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Which kind of index is preferred in DWH?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
What is the need of building a data warehouse?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What is synonym?
Explian the connected and unconnected lookup transformation
Teradata 
