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.


April 04, 2007 04:12:45 #3
 Vikas Jawa   Member Since: Visitor    Total Comments: N/A 

Merge two file in dataset
 
Use the funnel stage to merge the two files.
Also if you want to add a file to an existing dataset then you can wrtie to the same dataset wth dataset set to APPEND mode.
     

 

Back To Question