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 .
Partition in Join stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Partition in Join stage
Shivaranjani
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Re: Partition in Join stage
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]
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: