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
- 14460 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 how to import oracle sequence into informatica?
Explain the pipeline partition with real time example?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to generate sequence numbers without using the sequence generator transformation?
What are the data movement modes in informatica?
what is the -ve test case in your project.
Suppose we do not group by on any ports of the aggregator what will be the output?
What is mapping debugger?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is Data Caches size?
How to start a workflow using pmcmd command?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How union transformation is used?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is rank transform?
