1 lac of flat fles in source how to load target at a time?
- 4 Answers
- 10646 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the advantages of using informatica as an etl tool over teradata?
Write the different tools in the workflow manager?
What is joiner transformation in informatica?
Differentiate between a repository server and a powerhouse?
Why do we need informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are different types of transformations available in informatica?
Write the program through which the records can be updated?
What are the different components of powercenter?
What is a surrogate key?
What is the difference between source qualifier transformations source filter to filter transformation?
What do think which one is the better joiner or look up?
Explain the informatica workflow?
What is event and what are the tasks related to it?
