Link Partitioner

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

Link Partitioner

Post by snassimr »

Hi !

I want to split one source table to two tables according to column and specific value of this column . Suppose , if the column value is 1 load it to Target 1 and if 2 load to target 2.

If The Link Partitioner will help me ?
dsdesigner
Participant
Posts: 34
Joined: Thu Jul 29, 2004 1:03 pm

Post by dsdesigner »

Nope, you cannot use a link partitioner to achieve this. You can achieve this through a transformer, by using constraints.

Thanks,
Shekar
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Are there only 2 values?
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

Post by snassimr »

Yes . Only two values
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

You can use link-partitioner. But that will not be the best solution. As mentioned before, you are better-off using a transformer with 2 output links and constraints to dirvert the traffic.
Post Reply