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

Can you generate sequence numbers without using the sequence generator transformation?

672


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1734


What are the advantages of using informatica as an etl tool over teradata?

661


How many dimensions are there in informatica?

717


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

815






What are the reusable transformations?

779


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1399


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2066


What are the different components of powercenter?

679


What are the advantages of informatica?

661


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2219


Could you explain what is enterprise data warehouse?

646


Explain what is informatica metadata and where is it stored?

689


What do you understand by SOA of Informatica?

666


tell me the rules and responsblites in our project(my project is development)

1602