Concatenating two Input Datasets

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Raamc
Premium Member
Premium Member
Posts: 87
Joined: Mon Aug 20, 2007 9:08 am

Concatenating two Input Datasets

Post by Raamc »

Hi Friends,

In my job,i need to concatenate two datasets into a single dataset.I know that for this we can use funnel stage but the problem is my two input datasets are in different formats(Having different fields and different lengths) so funnel wil not work in this case.

Is there any best method is there to do this concatenation in Datastage Job? :!:

Thanks in Advance

Thanks
Raamc
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If they don't use the same format, what is the structure of the target?

The solution will probably involve two jobs, or two streams of activity within one job if the target rows are independent.

You've marked the thread as Resolved. How did you solve it?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply