How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
Answer Posted / jvdwhinfo
Hi Guys,
First of all create a new flat file and paste the location
of all the flat files in that newly created flat file.
Now import the source definition using "Import from file"
and define the mapping.
And assign the session properties as indirect file type of
loading and give the location of the newly created file.
This should do and please let me know if you want me to
discuss further.
Thanks,
James
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
Briefly explain the aggregator transformation?
What is meant by pre and post session shell command?
How we can create indexes after completing the load process?
What are the differences between oltp and olap?
What are the uses of etl tools?
difference between repository database and repository service?
What is the commit type if you have a transaction control transformation in the mapping?
How can you define user defied event?
What is the benefit of partitioning a session?
What do you understand by term role-playing dimension?
What is target designer and target load order?
Tell me about Propagate functions in informatica
Explain lookup transformation in informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?