Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between the join and look up
explin me one exmple
- 3 Answers
- 5778 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit gosain
Difference Between Join & Lookup:
1. In join stage you can do Inner Join, Left outer, Right
Outer and Full outer join, while in Lookup stage you can do
Inner join & Left outer join only.
2. In join stage you can't have a reject link, while in
lookup stage you can have a reject link for Unmatched
Primary records.
3. In join stage sorted data is mandatory, while in lookup
stage sorted data is not mandatory for lookup source.
4. Join stage requires Hash Partitioned data, while lookup
stage requires Entire partitioned lookup data.
5. In case of Join, Disk I/O is more while it's very less
in case of lookup (since at the time of matching, complete
lookup data is present in the memory).
6. In case of Join Stage, the key column name must be the
same in both the sources, while in case of lookup stage
it's not mandatory.
Cheers,
Ankit :)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the benefits of datastage?
which r the connectors used in san?
How do you import and export the datastage jobs?
Which warehouse using in your datawarehouse
Differentiate between data file and descriptor file?
How will you move hashed file from one location to another location?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How to convert RGB Value to Hexadecimal values in datastage?
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
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to abort the job its matain duplicates?
What are transforms and what is the differenece between routines and transforms?
how to implement scd2 in datastage 7.5 with lookup stage
