GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 109 of 390    Print  
what is merge and how it can be done plz explain with simple example taking 2 tables .......

  
Total Answers and Comments: 3 Last Update: April 29, 2006     Asked by: rcp 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 20, 2005 15:39:20   #1  
mallakishore Member Since: October 2005   Contribution: 7    

RE: what is merge and how it can be done plz explain w...
Merge is used to join two tables.It takes the Key columns sort them in Ascending or descending order.Let us consider two table i.e Emp Dept.If we want to join these two tables we are having DeptNo as a common Key so we can give that column name as key and sort Deptno in ascending order and can join those two tables
 
Is this answer useful? Yes | No
February 28, 2006 04:19:32   #2  
Sharanu Patil        

RE: what is merge and how it can be done plz explain w...
I think above answer is more then enough
 
Is this answer useful? Yes | No
April 29, 2006 06:57:16   #3  
madan        

RE: what is merge and how it can be done plz explain w...
Merge stage in used for only Flat files in server edition
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape