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
- 12507 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 repository manager?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is dimensional table?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Is there any target staging area in informatica not staging area
How do you update the records with or without using update strategy?
What does update strategy mean, and what are the different option of it?
What is rank index in rank transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is exclusive and normal mode for repository services?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain scd type 3 through mapping.
Explain lookup transformation is active in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
What is a snowflake schema?
