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 |
What is a shortcut and copy in Informatica and how two are different with each other?
Explain grouped cross tab?
What is a pre-defined event and user-defined event?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
what are the limitations of pushdown optimization technique ? Advance thanks
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
Suppose we do not group by on any ports of the aggregator what will be the output?