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
- 11945 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
What is persistent lookup cache?
how we can load rejected record's at run time?(not through bad files)
Can u generate reports in Informatica?
What are the tasks that source qualifier perform?
Explain what is informatica metadata and where is it stored?
what is the complex transformation you used in informatica
What is the function of aggregator transformation?
How is union transformation utilized?
What does command task mean?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is a surrogate key?
What is olap (on-line analytical processing?
How might one distinguish in the case of mapping is right or not without associating session?
Enlist the tasks for which source qualifier transformation is used.
What is difference between a gateway node and worker node?
