Partition in Join stage

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
G SHIVARANJANI
Participant
Posts: 137
Joined: Sun Jan 07, 2007 11:17 pm
Location: VISAKHAPATNAM

Partition in Join stage

Post by G SHIVARANJANI »

Hi,


Could any one explain what does partition do in join stage,

how can i disable the auto match in mappings , so that i can send :

say col 1:country into col b:surname .
Shivaranjani
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Proper key-based partitioning makes sure that, when a key value comes in from the left input, it can be sure that all occurrences of that key from the right input are on the same node as the value on the left input.

There is no auto-match in mappings in the Join stage. It just appears that way. You can override any mapping in the GUI on the Mapping tab for the Output link.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
G SHIVARANJANI
Participant
Posts: 137
Joined: Sun Jan 07, 2007 11:17 pm
Location: VISAKHAPATNAM

Re: Partition in Join stage

Post by G SHIVARANJANI »

Hi ,

if the mapping is this way


EXP------col_nm---- derivation---- colmnname

inp.col1--col1______ inp.col1------ col1
inp.col2--col2______ inp.col3------ col2
inp.col3--col3______ inp.col3------ col3


why am i getting inp.col2 in col2 of output when i traced out the result....

instead of getting inp.col3 in col2 of output.


its automatically putting the data as per the name of columns.. :-(
[/img][/url]
Shivaranjani
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What it puts is a default. Change it if you want it different.
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