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
- 5916 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
How will you move hashed file from one location to another location?
What are the types of hashed files in data stage
What is the difference between server job and parallel jobs?
What is oci?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are some different alternative commands associated with "dsjob"?
What is the different type of jobs in datastage?
Does datastage support slowly changing dimensions ?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is a merge in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
EXPLAIN SCD
What is the project in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
