| |
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 | |