Interested to Buy Any Domain ? << Click Here >> for more details...
Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 16636 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the different layers in the information server architecture?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Where do you see different stages in the designer?
Can you explain repository tables in datastage?
What all the types of jobs you developed?
Explain the situation where you have applied SCD in your project?
Differentiate between Join, Merge and Lookup stage?
Describe the architecture of datastage?
What steps should be taken to improve Datastage jobs?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is a ds designer?
What is the difference between in process and inter process?
Explain the importance of surrogate key in data warehousing?
Differentiate between validated and Compiled in the Datastage?
what is ds administrator used for?
