what is the main differences between Lookup, Join and Merge
stages?
Answer Posted / venugopal [patni]
The 3 stages differ mainly in the memory they use,
treatment of rows with unmatched & their requirements for
data being input.
In detailed:
Lookup is used for less amount of data becausu it will
takes the data from source and store in buffer so every
time it process from buffer.
Join is used for huge amount of data because it directly
takes the data from disk so it process faster than lookup.
Joiner is used to join with different join conditions.
Merge is also used for huge amount of data. Merge has the
same number of reject links as there are updated updated
input links.
Is This Answer Correct ? | 108 Yes | 15 No |
Post New Answer View All Answers
Can you explain kafka connector?
how to write server Routine coding?
What is job control?
What is ibm datastage?
What are the processing stages?
How complex jobs are implemented in datstage to improve performance?
I have a few records just I want to store data in to targets cycling way how?
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.
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
what is use of SDR function?
What is the command line function to import and export the ds jobs?
how can we create rank using datastage?what is the meaning of rank?
Explain the situation where you have applied SCD in your project?
How to reverse the string using unix?
What are the different common services in datastage?