1 lac of flat fles in source how to load target at a time?
- 4 Answers
- 9947 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 |
Can we update a target table (without primarykey) by using update strategy transformation?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
can we see default group,when we use router?if yes how?
I want load the data into target with out 1st and last record.
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
In which circumstances that informatica server creates Reject files?
Global and Local shortcuts. Advantages.
How to update or delete the rows in a target, which do not have key fields?
In a sequential batch can you run the session if previous session fails?
Explain informatica architecture - version 8 / 9
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
what is data modelling? what are types of modelling?In which suituation will use each one?
Teradata 
