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
- 11956 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
Explain the pipeline partition with real time example?
What is an unconnected transformation?
What are the types of data warehouses?
Differentiate between source qualifier and filter transformation?
How to create or import flat file definition in to the warehouse designer?
What is exclusive and normal mode for repository services?
Clarify the utilization of aggregator cache record?
what is $$$$?
How to create Target definition for flat files?
How can we create index after completion of load process?
How can we remove the duplicates from flat file source?
How to extract sap data using informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is data transformation manager process?
What is informatica worklet?
