Join Stage

[khaja.arshad]

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

[Kirtikumar]

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.

[khaja.arshad]

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

[Kirtikumar]

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.

[khaja.arshad]

Thanks Kumar

Now it's working
The problem was even though the fields were having the same size there was some trailing spaces

i have done trim function..now it's working

instead of trnasformer im going to use the Modify stage..let's see hw it will work

[kumar_s]

If both the stream keys are varchar, shouldnt it take care by it self?

[ray.wurlod]

No. DataStage does not change the data. If there are trailing spaces in the data (for example) then they're there.

[khaja.arshad]

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

[ray.wurlod]

string_trim[character,direction,justify](string)

or

trim_leading_trailing(string)

See page 13-7 of Orchestrate Operators manual for full details.

[ukyrvd]

If both the stream keys are varchar, shouldnt it take care by it self?

no .. it can only handle variable length values

like varchar 10 can handle "abc" "abc1234567" .. but it still treats "abc " different from the way it treats "abc"