Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148586 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / maruthi
ALL THESE THREE(MERGE,JOIN,LOOKUP) ARE USED TO JOIN TABLES
BASED ON THE KEY COLUMNS. AND THE DIFFERENCES ARE:
1.)MAIN DIFFERENCE:ALL THESE THREE WILL DIFFER ON THE
POPULATION OF DATA ONCE AFTER KEY COLUMN MATCHES,AND THE
MEMORY USED TO STORE TABLES.
MERGE:-CAN HAVE ANY NUMBER OF INPUT LINKS,SINGLE O/P
LINK,AND NO OF REJECT LINKS AS MANY OF UPDATE LINKS,SO WE
CAN HAVE REJECT DATA IN ANOTHER TABLES,(JOINER DONT
SUPOERTS ANT REFERENCE OR REJECT LINKS)
| Is This Answer Correct ? | 42 Yes | 26 No |
Post New Answer View All Answers
what are the errors,warnings in datastage
How do you import and export the datastage jobs?
Why do we use link partitioner and link collector in datastage?
Give an idea of system variables.
Explain usage analysis in datastage?
What are the components of datastage?
What are the important features of datastage?
What are the benefits of datastage?
explain about citrix scheduling tool in datastage
Differentiate between data file and descriptor file?
how to implement scd2 in datastage 7.5 with lookup stage
How can you write parallel routines in datastage PX?
How many types of hash files are there?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is size of a transaction and an array means in a datastage?
