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
- 2674 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / bhavemanali10
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 |
Post New Answer View All Answers
how do u handle performance issues in Informatica . where can u monitor the performance ?
Compare ETL & Manual development?
what is pmrep command?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Give the benefits of data integration suite?
What is tracing level and what are the types?
Which transformation we use to convert 'NA' to 'Not Available'
Explain about hash partitioning?
when will use SQL override in a lookup transformation?
What are your responsibilities as an etl tester?
what is the main role of FI on business
What is the difference between Data Warehousing and Data Mining?
Difference between flat files and relational sources?
Explain about round-robi?
how do u really know that paging to disk is happening while u are using a lookup transform?
