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
- 5879 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 engine tier in information server?
How do u convert the columns to rows in datastage?
What is staging variable?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is the use of materialized view?
What are the functionalities of link partitioner?
How one source columns or rows to be loaded in to two different tables?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Explain how a source file is populated?
What is the difference between passive stage and active stage?
What are the different types of lookups in datastage?
Nls stands for what in datastage?
Differentiate between hash file and sequential file?
