I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
Answer Posted / kvikas2056
Thank you manali,
But can you please explain why joiner is better than lookup??
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the use of server manager?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
what is the meant by Normalization and de-normalization?
Do we need an ETL tool? When do we go for the tools in the market?
What is data modeling and data mining?
what is the difference between cubes and package in cognos
how many steps are there in etl process?
Compare etl & elt?
How to fine tune mappings?
Is hadoop a etl tool?
How many steps etl contains?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Explain etl mapping sheets?
Can there be sub steps of etl steps?