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
- 14366 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
How would you join a node to the already existing domain?
Enlist the differences between database and data warehouse.
What are the measure objects?
COM components can be used in Informatica
What are the different options available for update strategy?
What is a connected transformation?
What is complex mapping?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the commit type if you have a transaction control transformation in the mapping?
How do you migrate data from one environment to another?
What is an Integration service in Informatica?
What is the Rank index port in Rank transformation?
Scheduling properties,whats the default (sequential)
What is the reusable transformation?
Explain direct and indirect flat file loading (source file type) - informatica
