Difference in the implementation of lookup and join
stages,in joining two tables?
Answer Posted / sadanand
HI All,
I would like to add one more point to JOIN.
To achieve full outer join the number of inputs need would
be only two.
The Primay table need to be sorted.
Memory used is very less compared to Lookup.
Regards,
Sadanand.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which commands are used to import and export the datastage jobs?
Describe routines in datastage? Enlist various types of routines.
Explain Quality stage?
What is apt_config in datastage?
What is the purpose of pivot stage?
What is the difference between server job and parallel jobs?
Is the value of staging variable stored temporarily or permanently?
Define Merge?
What are the types of containers and how to create them?
Is it possible to query a hash file?
Can you define merge?
What are the types of views in datastage director?
How many types of hash files are there?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is data partitioning?