Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
- 2 Answers
- 3776 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Joiner Transformation is better in case of heterogeneous join(join 2 tables exist in the different database).
While lookup and SQ is better approach to join two tables which exist in same database
| Is This Answer Correct ? | 1 Yes | 0 No |
Thank you manali,
But can you please explain why joiner is better than lookup??
| Is This Answer Correct ? | 0 Yes | 0 No |
What is grain of fact?
what is different between sequential batch and concurrent batch and which is recommended and why?
Compare etl & elt?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
when will use SQL override in a lookup transformation?
What are the three tiers in etl?
What is etl process. How many steps etl contains explain with example?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
How to fine tune mappings?
How etl testing is different from database testing?
Teradata 
