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
- 14715 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / schwab
Hi,
Yes U can do it by merging all 10 flat files in one single
file.
create a script before session(presession) to merge all
these files into one.
This is the way we are handling in our project.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
how tokens will generate?
Clarify the aggregator change?
What is session task and command task?
Enlist the differences between database and data warehouse.
How to delete duplicate row using informatica?
How many dimensions are there in informatica?
Does an informatica transformation support only aggregate expressions?
What are the new features of Power Center 5.0?
How to load the data from people soft hrm to people soft erm using informatica?
How to implement security measures using repository manager?
Why sorter is an active transformation?
What is the difference between Active and Passive transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is a node in Informatica?
