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
how many types of dimensions are available in informatica?
What is decode in informatica?
I have a flat file, want to reverse the contents of the flat file
What are ETL Tools?
How many dimensions are there in informatica?
What is the difference between Active and Passive transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
In informatics server which files are created during the session rums?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is enterprise data warehousing?
What is the format of informatica objects in a repository?
Define mapplet?
How to extract the informatica rejected data?
Mention some types of transformation?
What is powercenter on grid?