what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144865 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
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
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 the datastage stored his repository?
what are the errors,warnings in 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
which r the connectors used in san?
What are the different type of jobs in datastage?
Lookup constraints
How a server job can be converted to a parallel job?
What are the benefits of datastage?
What steps should be taken to improve Datastage jobs?
What is the purpose of pivot stage?
What is datastage engine?
What is orabulk stage?
how to add a new records into source?
