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
- 5878 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 is the command line function to import and export the ds jobs?
What are the types of containers in datastage?
What is "fatal error/rdbms code 3996" error?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Does datastage support slowly changing dimensions ?
What is the use of datastage director?
How do you reject records in a transformer?
how to abort the job its matain duplicates?
Demonstrate experience in maintaining quality process standards?
Differentiate between data file and descriptor file?
Can you explain link buffering?
How rejected rows are managed in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between datastage and datastage tx?
Describe the main features of datastage?
