| |
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. |
| May 05, 2007 12:31:19 |
#5 |
| gagan8877 |
Member Since: May 2007 Total Comments: 8 |
RE:
| Use the merge plug-in stage which can merge two files based on the defined key fields by using, INNER or OUTER joins, UNION, Intersection or Minus operations. |
| | |
Back To Question | |
