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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define mapplet?

627


What is exclusive and normal mode for repository services?

713


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1561


Slowly changing dimensions, types and where will you use them

1274


Performance tuning in UNIX for informatica mappings?

2145






What are the issues you have faced in your project? How did you overcome those issues?

1914


Informatica settings are available in which file?

591


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

679


Is there any target staging area in informatica not staging area

2126


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1636


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1136


Partition, what happens if the specified key range is shorter and longer

2031


What is the need of etl tools?

613


What is the difference between stop and abort in informatica

666


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

629