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
- 5913 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
Demonstrate experience in maintaining quality process standards?
What are the important features of datastage?
What is the method of removing duplicates, without the remove duplicate stage?
What all the types of jobs you developed?
How do y read Sequential file from job control?
Describe routines in datastage? Enlist various types of routines.
What is the sortmerge collector?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the difference between server job and parallel jobs?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are datastage sequences?
What are the repository tables in datastage?
How to perform incremental load in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is use Array size in datastage
