Join Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Mon May 29, 2006 11:19 pm
Join Stage
Hello All
I have Two Sequential files
Iam Joining these two Files Using Join Stage based on the Key Column Which is a varchar..im Using the same column name to join these Files
It getting compiled but ..During run time no value is Coming out of the Join Stage
I have tried with to search the Forum but i am unable to get results bcoz of Network restrictions in our Organisation
Any help would be highlyAppriciated
Thanks in Advance
I have Two Sequential files
Iam Joining these two Files Using Join Stage based on the Key Column Which is a varchar..im Using the same column name to join these Files
It getting compiled but ..During run time no value is Coming out of the Join Stage
I have tried with to search the Forum but i am unable to get results bcoz of Network restrictions in our Organisation
Any help would be highlyAppriciated
Thanks in Advance
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
Few questions for you-
1. What is the type of join? If inner, are you sure there is at least one row in both file where you have same key value.
2. What type of partitioning are you doing for input links in the join stage?
Sometimes even if you have same metadata in both the files for key columns, actual value may not match.
E.g. If I am matching on column NAME defined as VC(10). In file the value will be 'AAA ' (has space after value)and in one file value might be 'AAA'. So when you view data, you will see they have same values.
So before joining VC columns, ensure that they do not have unnecessary spaces in their value by trimming leading and trailing spaces.
1. What is the type of join? If inner, are you sure there is at least one row in both file where you have same key value.
2. What type of partitioning are you doing for input links in the join stage?
Sometimes even if you have same metadata in both the files for key columns, actual value may not match.
E.g. If I am matching on column NAME defined as VC(10). In file the value will be 'AAA ' (has space after value)and in one file value might be 'AAA'. So when you view data, you will see they have same values.
So before joining VC columns, ensure that they do not have unnecessary spaces in their value by trimming leading and trailing spaces.
Regards,
S. Kirtikumar.
S. Kirtikumar.
-
- Participant
- Posts: 30
- Joined: Mon May 29, 2006 11:19 pm
Hi Kumar
Im Using inner join on Mobile_Number which is Varchar(15) in both files and im doing hash partetioning on Both
It seems to be correct what you said on Trim
But my sources to the Join Stage are Sequential files
Can you please tell me hw to do the Trim on Seqential file column which are directly connectiong to the Join Stage
Im Using inner join on Mobile_Number which is Varchar(15) in both files and im doing hash partetioning on Both
It seems to be correct what you said on Trim
But my sources to the Join Stage are Sequential files
Can you please tell me hw to do the Trim on Seqential file column which are directly connectiong to the Join Stage
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
First have you check whether you have at least one row in input where you have same value for column mobile number?
If not, add/update one records to have same number.
To trim the these columns, you will have to use transformer stage. There use the TrimLeadingTrailing function on the mobile number column and then send it to the join stage.
If not, add/update one records to have same number.
To trim the these columns, you will have to use transformer stage. There use the TrimLeadingTrailing function on the mobile number column and then send it to the join stage.
Regards,
S. Kirtikumar.
S. Kirtikumar.
-
- Participant
- Posts: 30
- Joined: Mon May 29, 2006 11:19 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 30
- Joined: Mon May 29, 2006 11:19 pm
Modify Stage-Trim-Data
Hello Ray
Can you Please Share your knowledge Hw Modify stage handle leading and trailing Space ..
Iam asking Trimming of the Data.
Thanks in Advance
Can you Please Share your knowledge Hw Modify stage handle leading and trailing Space ..
Iam asking Trimming of the Data.
Thanks in Advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
string_trim[character,direction,justify](string)
or
trim_leading_trailing(string)
See page 13-7 of Orchestrate Operators manual for full details.
or
trim_leading_trailing(string)
See page 13-7 of Orchestrate Operators manual for full details.
Last edited by ray.wurlod on Thu Oct 12, 2006 2:27 pm, edited 1 time in total.
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.