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??
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
What are the different types of transformation available in informatica.
What are data-driven sessions?
What is mapplet in informatica?
Describe expression transformation?
What is informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is a sequence generator transformation?
How many types of sessions are there in informatica.please explain them?
Differentiate between a database and data warehouse?
Is stop and abort are same in informatica?
Explain the features of connected and unconnected lookup.
Is it possible to use a client with different version than that of its Informatica server?
What is a code page?
How do you load unique records into one target table and duplicate records into a different target table?
Define joiner transformation?