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
- 11944 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
Yes BZZ,,,
After assign the folder path in Source path,
We have to change source Type as INDIRECT in Session
properties.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is Data Caches size?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Plz can any one say me how to get the informatica certification materials and dumps
write a query to retrieve the latest records from the table sorted by version(scd)
What is substr in informatica?
Explain the tuning lookup transformation - informatica
What is meant by lookup transformation? Explain the types of lookup transformation?
lookup transformation with screenshots
Is it possible to create multiple domains on a single Informatica server?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain the types of transformations?
How can you define user defied event?
Differentiate between router and filter transformation?
Enlist the differences between database and data warehouse.
