Difference in the implementation of lookup and join
stages,in joining two tables?
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 difference between symmetric multiprocessing and massive parallel processing?
Enlist various types of routines in datastage.
Triggers,VIEW,Procedures
How the ipc stage work?
Explain datastage architecture?
Why do we use exception activity in Datastage?
Difference between data warehousing and olap?
Notification Activity
How to read multiple files using a single datastage job if files have the same metadata?
How you can fix the truncated data error in datastage?
Could anyone give brief explanation bout datastage admin
Name the different types of Lookups in Datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Differentiate between datastage and informatica?
What is the purpose of interprocessor stage in server jobs?