Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149012 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
What are routines in datastage?
What is a folder? Difference types of stages?
What is the difference between the local container and shared container?
Explain ibm infosphere information server and highlight its main features?
What are constraints and derivations?
What is the difference between operational data stage (ods) and data warehouse?
Can you explain players in datastage?
What is process model?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the types of containers?
What is the flow of loading data into fact & dimensional tables?
Enlist various types of routines in datastage.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the enhancements made in datastage 7.5 compare with 7.0?
Where do you see different stages in the designer?
