Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

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




725
views
asked marvit September 20, 2014 08:01 AM  

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


           

1 Answers



 
answered By vishnoiprem   0  
Method 1:

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 will have DIRECT and we should give the file,which will have the addresses of all the Flat files which we are going to merge.

Method 2:

By using a concept called file merging we will give the path of all files in a single file and in session properties select file type is indirect
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  2 people following this tag

  Question tags

informatica × 1

Asked 3 years and 5 months ago ago
Number of Views -725
Number of Answers -1
Last updated
3 years and 2 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert