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
- 14377 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
Which transformation is needed while using the Cobol sources as source definitions?
How to open an older version of an object in the workspace?
What is informatica metadata and where is it stored?
Explain sql transformation in script mode examples in informatica
what are the deliverables?in your project?
How to load data in informatica ?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a snowflake schema?
Plz can any one say me how to get the informatica certification materials and dumps
What is Index Caches size?
Explain the code page compatibility?
what is size of u r database?
tell me 5 session failure in real time how can you solve that in your project?
What if the source is a flat-file?
Which files are created during the session rums by informatics server?
