How do you Merge multiple Flat files for example 100 flat files with out using

How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F

Question Posted / karan_kapoor603

4 Answers
18515 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F..

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

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F..

Answer / chandrababu naidu

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

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F..

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

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F..

Answer / alok

Phani, it will be great if u can elaborate this.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer