GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 291 of 327    Print  
Join Flatfile Sources
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.


  
Total Answers and Comments: 4 Last Update: August 25, 2008     Asked by: contact.manaskumar 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 01, 2008 12:36:59   #1  
mayur.data Member Since: April 2008   Contribution: 1    

RE: Join Flatfile Sources
Hi

You can Join two falt files using Joiner and as well as Looup. As far as performance is considered Joining using look up would give you better performance.

 
Is this answer useful? Yes | No
April 09, 2008 12:08:50   #2  
Noel Lastra Member Since: February 2007   Contribution: 38    

RE: Join Flatfile Sources
Hu! Have you tried joing two flat files before ?
 
Is this answer useful? Yes | No
July 26, 2008 17:44:36   #3  
Mamta11 Member Since: July 2008   Contribution: 12    

RE: Join Flatfile Sources
Use joiner transformation. If the structure of both the flat files is same you can also use union transformation
 
Is this answer useful? Yes | No
August 25, 2008 05:02:19   #4  
sakthi.jaganathan Member Since: August 2008   Contribution: 8    

RE: Join Flatfile Sources
The only way to join two flat file is joiner transformation
if the structure of the two flat file is same and the datatypes also matches we can use union transformation but it wont join the flat files it will merge the flat flies. In informatica the union transformation will act as a unionall function.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape