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
- 6028 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
Can you explain kafka connector?
whom do you report?
What is the difference between datastage and datastage tx?
What are the types of views in datastage director?
How to perform incremental load in datastage?
Name the third party tools that can be used in datastage?
how to add a new records into source?
How rejected rows are managed in datastage?
Enlist various types of routines in datastage.
Explain how a source file is populated?
What is aggtorec restructure operator?
Terminate Activity
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is difference between symmetric multiprocessing and massive parallel processing?
