Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 15362 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
Generally we are using lookup for comparision purpose,
based on the reference table size we r using join or lookup.
If the reference table size is less than the main table
then use lookup stage other wise use join stage.
In lookup we have two types:
Normal lookup - reference lookup is less no of rows
compared to main table
sparse lookup - reference lookup is more no of rows
compared to main table.
But the peformance wise use join if the reference table has
more data.
Regards,
Krishna
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the use of datastage designer?
What a datastage macro?
How to Remove Duplicate using SQL?
table actions available in oracle connector?
What are the difference types of stages?
Name the different sorting methods in datastage.
what is ds administrator used for?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the benefits of datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are iconv and oconv?
whom do you report?
What is the difference between validated and compiled in the datastage?
On which Dimension Table you implemented SCD Type in your Project
What is the difference between odbc and drs stage?
