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
Name the command line functions to import and export the DS jobs?
What is the purpose of pivot stage?
Have you used Unstructured data?
Can you implement SCD2 using join, transformer and funnel stage?
What is aggtorec restructure operator?
How to RD using transformer?
What all are the different way to run a job?
How a source file is populated?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Can we use target hash file as a lookup ?
What are the important features of datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the difference between the local container and shared container?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also