what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144744 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
How the ipc stage work?
Distinguish between informatica & datastage. Which one would you choose and why?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the main differences you have observed between 7.x and 8.x version of datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the different options associated with dsjob command?
explain about citrix scheduling tool in datastage
How can we improve the performance in datastage?
whom do you report?
Describe stream connector?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
table actions available in oracle connector?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
