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
can u any challenge your project?
What is the difference between Active and Passive transformation?
How do you promote a non-reusable transformation to reusable transformation?
How can you increase the performance in joiner transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to do unit testing in informatica?
How can we use mapping variables in informatica? Where do we use them?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain how many types of dimensions are available in informatica?
Mention few power centre client applications with their basic purpose?
How can repository reports be accessed without sql or other transformations?
Difference between Data and Index Caches?
What is lookup transformation?
What is the benefit of partitioning a session?
What is dynamic cache?