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
- 6027 Views
- I also Faced
- E-Mail Answers
Answer Posted / anburadh
1.Join needs key column metadata should be same|Lookup key column metadata its not mandatory to be same
2.Implement Four join in JOIN|But in Lookup only TWO JOIN(left outer,INNER)
3.JOIN does not have reject link | LOOKUP has one reject link
4.Data should be sorted and default is hash partioning |LOOKUP data need not to be in sort and default partioning is ENTIRE
5.Performance is HIGH in JOIN | Performance is less in JOIN
6.Duplicate will arise in JOIN|can handle Duplicate in LOOKUP
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are constraints and derivations?
Explain datastage architecture?
What is the difference between datastage and datastage tx?
How do you start developing a datastage project?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the differences between datastage and informatica?
How do you import and export data into datastage?
What are datastage sequences?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you filter data in hashed file?
Why do you need stage variables?
Can you explain tagbatch restructure operator?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Can we use target hash file as a lookup ?
how to write server Routine coding?
