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
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Write the unconnected lookup syntax?
Enlist few areas or real-time situations where informatica is required.
What is the Rank index port in Rank transformation?
What is rank transform?
What is meant by query override?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to do unit testing in informatica?
Could you explain what is enterprise data warehouse?
What is the way to execute pl/sql script using informatica mapping?
Explain transaction control transformation in informatica
What is the status code in stored procedure transformation?
What is decode in static cache?
Target increases every day even though no new record was inserted
Explain the features of connected and unconnected lookup.