GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Informatica

 Print  |  
Question:  What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use.



February 02, 2007 03:39:20 #3
 sai   Member Since: Visitor    Total Comments: N/A 

RE: What is the difference between using Joiner and Us...
 
joiner is used to join the data from hetrogenious database plotforms or from the same plotform.lookup is used to join the data from relational database .if u want to join the all columns data from different tables having a common column from hetrogenious database plotforms or from the same plotform joiner is preferable.if u want to join the data in perticular columns from relational database it is preferible to use lookup transf, it will improve the session performance .
     

 

Back To Question