Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148601 Views
- HCL, I also Faced
- E-Mail Answers
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
Describe the main features of datastage?
Can we use target hash file as a lookup ?
What is the difference between datastage and informatica?
What is a merge in datastage?
Where do the datastage jobs get stored?
how many rows sorted in sort stage by default in server jobs
Explain connectivity between datastage with datasources?
What is the process of killing a job in datastage?
How we can covert server job to a parallel job?
What are sequencers?
Give an idea of system variables.
project Steps,hits, Project level HArd things,Solved methods?
sed,awk,head
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Can you explain repository tables in datastage?
