How do you merge two files in DS?

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.
  • Interview Candidate
  • 11
  • 13546

Showing Answers 1 - 11 of 11 Answers

chetan

  • Aug 31st, 2005
 

Using Funnel stage you can merge the data from two files together.

  Was this answer useful?  Yes

DsDeveloper

  • Aug 31st, 2006
 

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.

  Was this answer useful?  Yes

Vikas Jawa

  • Apr 4th, 2007
 

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.

  Was this answer useful?  Yes

hanug

  • May 6th, 2007
 

We can use either FUNNEL stage or use the sequentil stage and read more then one file(both files format should be same).

Hanu.

  Was this answer useful?  Yes

gagan8877

  • May 8th, 2007
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions