GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage

 Print  |  
Question:  How do you merge two files in DS?

Answer: Either used Copy command as a Before-job subroutine if the metadata of the 2 files are same or created a job to concatenate the 2 files into one if the metadata is different.


August 08, 2006 11:07:56 #2
 DsDeveloper   Member Since: August 2006    Total Comments: 1 

RE:

There is a Merge Stage in Parallel Jobs.

Here you can give one Master data  set (file) and any number of  updated data set (files). The output will be  merge of Master and updated data sets along with reject data set. The number of reject data sets are equal to the number of updated data sets.

The output data set will be all the columns from Master data set plus any additional columns from the updated data set. Here the key column values of master and update data sets must be same.

     

 

Back To Question