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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

867


what is degenerated dimension?

3497


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1351


Differentiate between router and filter transformation?

795


How do you take back up of repository?

914


What is a sorter transformation?

880


Define pmcmd command?

806


can anyone suggest best free Talend data integration training online

1471


Is there any way to read the ms excel datas directly into informatica?

760


What are the conditions needed to improve the performance of informatica aggregator transformation?

813


What are the main issues while working with flat files as source and as targets ?

899


Describe data concatenation?

777


What are the differences between joiner transformation and source qualifier transformation?

879


How can we remove the duplicates from flat file source?

783


State the limitations where we cannot use joiner in the mapping pipeline?

759