Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 9 Answers
- 14107 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / harish konda
Yes we can load all these flat files in a single session.
First create a txt file and in that give all the file names
along with their PATH.
Drag any one of the flat file into the mapping and link it
to the target acc. to your requirement.
And in the session properties give the file type as Indirect
and in Filename option, give the file name(along with the
path) of the file in which you gave all the paths.
Then run the mapping.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Describe data concatenation?
To import the flat file definition into the designer where should the flat file be placed?
can anyone explain me about retail domain project in informatica?
What is decode in static cache?
What is the difference between a connected look up and unconnected lookup?
What are the types of caches in lookup?
Can u generate reports in Informatica?
What are the different types of transformation available in informatica.
What do you mean by filter transformation?
Explain what is informatica metadata and where is it stored?
Differences between version 7.x and 8.x.
What is meant by pre and post session shell command?
What is event and what are the tasks related to it?
how to load dimension table and fact table. plz tell me the steps.
Explain the different kinds of facts.
