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
- 5783 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 flow of project?
Have you have ever worked in unix environment and why it is useful in 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 are some prerequisites for datastage?
What is "fatal error/rdbms code 3996" error?
sed,awk,head
How many Key we can define in remove duplicate stage?
What is job control?
How to implement complex jobs in data stage?
How many types of stage?
describe the Steps to confiure a Qlogic switch
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are system variables and sequencers in datastage
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How one source columns or rows to be loaded in to two different tables?
