what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144819 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
Differentiate between data file and descriptor file?
What is the difference between datastage and datastage tx?
Describe the main features of datastage?
What is the differentiate between data file and descriptor file?
Name the command line functions to import and export the DS jobs?
Describe the architecture of datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what is ds administrator used for?
What is the difference between operational data stage (ods) and data warehouse?
Does datastage support slowly changing dimensions ?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How many types of sorting methods are available in datastage?
Demonstrate experience in maintaining quality process standards?
What are constraints and derivations?
How to reverse the string using SQL?
