There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??
Answer Posted / sankar
FOR THOSE FLAT FILE WE CREATE A LIST FILE.IN THAT LIST FILE
WE CAN ENTER FLAT FILE DIRECTRIES.
THEN GO TO SESSION
SOURCE TYPE:INDERECT
SOURCE DIRECTOTRY:LIST DIRECTORY
SOURCE FILENAME:LIST.TXT
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
How can repository reports be accessed without sql or other transformations?
Tell me about Propagate functions in informatica
What are the informatica performance improvement tips
What are the databases that informatica can connect to windows?
What is the difference between a connected look up and unconnected lookup?
Differentiate between a repository server and a powerhouse?
Explain constraint based loading in informatica
Explain about cumulative Sum or moving sum?
How can you generate reports in informatica?
What is a pre-defined event and user-defined event?
What do you mean by worklet?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the types of caches in lookup? Explain them.
How can we improve session performance in aggregator transformation?