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
- 3879 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
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
What are cubes and olap cubes?
What is etl process. How many steps etl contains explain with example?
Difference between flat files and relational sources?
What is a materialized view log?
What are the names of the layers in etl?
what happens if the info.server doesn't find the session parameter in the parameter file?
list and discuss two approaches for updation of target table in Informatica and how they are different.
State the differences between shortcut and reusable transformation
Explain what are the various etl tools in the market?
What is data modeling and data mining?
Do we need an etl tool?
What is the difference between project backlog and product backlog?
Can we create Hierarchies in generic datasources?
what is an ETL or ETT? And what are the different types?
