Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149043 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
Define APT_CONFIG in Datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How can we improve performance of data stage jobs?
How to reverse the string using SQL?
State the difference between an operational datastage and a data warehouse?
What is staging variable?
Can you highlight the main features of ibm infosphere information server?
What is active and passive stage?
What are the some differences between 7.x and 8.x version of datastage?
What are some different alternative commands associated with "dsjob"?
What is a merge?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is difference between join, merge and lookup stage?
How do you schedule or monitoring the job?
What is the purpose of pivot stage?
