How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
Answers were Sorted based on User's Feedback
Answer / phani
By using File List we can Merge more than one Flat file.
when we are importing more than one flat file we should Set
the Source Property as INDIRECT,where default property ll
have DIRECT. and we should give the file,which ll have the
adresses of all the Flat files which we are going to merge.
Is This Answer Correct ? | 20 Yes | 4 No |
by using a concept called filemerging
we will give the path of all files in a sinle file
and in session properties select file type is indirect
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Define update strategy?
what is curr val use for in sequence generator?
How can we get multiple output values using an unconnected lookup transformation?
What are the components of the workflow manager?
how do u tune queries?
How to delete duplicate records in a flat file source?
What is a filter transformation?
How can you run a session without using server manager?
Explian the Process of deployment groups in informatica
Can we create multiple integration service on single repository?
What are the main issues while working with flat files as source and as targets ?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?