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 |
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
what is the difference between informatica6.1 and infomatica7.1
Can you access a repository created in previous version of Informatica?
how u know when to use a static cache and dynamic cache in lookup transformation.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to delete first 3 rows & last 3 rows in target table in informatica
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
I want load the data into target with out 1st and last record.
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
What is informatica? Why do we need it?