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
what is the size of your data warehousing?
How to Create a folder using pmrep command?
How do you load only null records into target? Explain through mapping flow.
Make a note of the quantity vaults made in informatica?
Explain the difference between a data warehouse and a data mart?
Design time, run time. If you don't create parameter what will happen
What is standalone command task?
r u done any partitions in ur project?
What are the different components of powercenter?
where to store informatica rejected data?
What is lookup change?
Where do we use mapping variables in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
What are the new features of informatica 9.x in developer level?
How you can differentiate between connected lookup and unconnected lookup?