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
- 12505 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi,,,TCS,,,
Have you attend Recently for TCS,,,?
You need to load 10flatfiles to One relational source,,?
You can keep 10flat files in a single folder.Just assign
the folder path as a Source path in SESSION PROPERTIES.
it will make it 1 flatfile source.
By a simple Mapping,make it single Relational source.
Any corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
What is the difference between stop and abort in informatica
Explian the Process of deployment groups in informatica
What do think which one is the better joiner or look up?
What is rank transformation?
What are session parameters ? How do you set them?
how to create user defined function (udf) in informatica
What are the designer tools for creating transformations?
How to load the data from people soft hrm to people soft erm using informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
is it possible to index the data in cache of lkp transformation ?
Did u used latest transformations of 8.6.0? for what?
Define the various join types of joiner transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is sq transformation?
How to load last n records of file into target table - informatica
