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
- 12510 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
How can we use batches?
Explain what are the different versions of informatica?
Explain in detail about scd type 1 through mapping.
Why do you use Mapping Parameter and mapping variable?
Define mapplet?
How can you differentiate between powercenter and power map?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to generate sequence numbers using expression transformation?
What does update strategy mean, and what are the different option of it?
Quickly characterize reusable change?
What is informatica etl tool?
What is the difference between STOP and ABORT options in Workflow Monitor?
What does cheating measurement mean?
tell me the rules and responsblites in our project(my project is development)
What are the static cache and dynamic cache in informatica?
