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
Triggers,VIEW,Procedures
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Lookup constraints
What is data partitioning?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Why do you need stage variables?
Terminate Activity
describe the Steps to confiure a Qlogic switch
What is the command line function to import and export the ds jobs?
On which interface you will be working as a developer?
What is a folder? Difference types of stages?
What are some different alternative commands associated with "dsjob"?