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
Please let me know how to make encryption and decryption with example?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
differences between service based and product based?
How can we delete duplicate rows from flat files?
Informatica Checkpoints
What differs when we choose the sorted input for aggregator transformation?
What you know about transaction control transformation?
What is a stored procedure transformation?
How do you migrate data from one environment to another?
how to create user defined function (udf) in informatica
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is lookup change?
How does a sorter cache works?
How to update or delete the rows in a target, which do not have key fields?