DataStage - How do you merge two files in DS?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 42 of 376

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.

Total Answers and Comments: 5

Last Update: May 08, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 31, 2005 03:52:21

chetan

RE: How do you merge two files in DS?

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

Is this answer useful? Yes | No

August 31, 2006 11:07:56	#2
DsDeveloper		Member Since: August 2006 Contribution: 1
RE: Yes \| No

April 04, 2007 04:12:45

Vikas Jawa

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.

Is this answer useful? Yes | No

May 06, 2007 22:54:44	#4
hanug		Member Since: June 2006 Contribution: 24
RE: Yes \| No

May 08, 2007 12:31:19	#5
gagan8877		Member Since: May 2007 Contribution: 8
RE: Yes \| No

Go To Top