Difference in the implementation of lookup and join
stages,in joining two tables?
Answer Posted / zulfi123786
Hi This is Zulfi
Basically Join is used when you have large amount of data
about in millions and it performs inner join,left
outer,right outer and full outer joins
The join stage requires the incomming data to be hash
partitioned and sorted on the joining keys
The look up is used when the reference records are fewer in
number about less than one lakh and it doesnot require the
incomming source data to be sorted, instead the refrence
link should be in Entire partition mode.
In look up there are two types
Normal and Sparse
Sparse is available only when the reference is a database.
usually Normal has to be used unless when the refrence to
source rows ratio is 100:1
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is a quality stage in datastage tool?
What is a folder? Difference types of stages?
Where do the datastage jobs get stored?
why do u need the IOS upgradation in a FC switch
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
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 are the repository tables in datastage?
What is the importance of the exception activity in datastage?
What is the difference between Datastage 7.5 and 7.0?
What is the difference between validated and compiled in the 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
Define Merge?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?