Merge stage question

aakashmalu · Post by **aakashmalu** » Sat Sep 19, 2009 4:55 pm

Hi,

I wrote a parallel job which extracts data from different tables in oracle and writes them in to different datasets. In the next job i am merging all these datasets with the master dataset and the key is acct_id in all the datasets, but i have one dataset whose key is ACCT_ID in upper case. When i ran this job it is giving me the desired results. Now my question is does datasets with key column in different cases join correctly, in my case it seems to work, can anybody explain this why this is working because in the manual it says key column with different case doesn't work .

Thanks in advance
AM

chulett · Post by **chulett** » Sat Sep 19, 2009 5:14 pm

I would assume they mean the case of the key column data, not of the column names.

aakashmalu · Post by **aakashmalu** » Sat Sep 19, 2009 8:45 pm

chulett wrote:I would assume they mean the case of the key column data, not of the column names. ...

Craig,

It is column names not the column data.

Thanks
AM

aakashmalu · Post by **aakashmalu** » Sat Sep 19, 2009 9:29 pm

Craig,

I think i misinterpreted CASE SENSITIVE option in the Manual.
So you mean to say this about column data not column name(Key) right?

Thanks for your help....
AM

chulett · Post by **chulett** » Sat Sep 19, 2009 9:43 pm

Yes, correct, as noted the data. It could care less about the case of the column names, but you have the option to make it care about the case of the key column join data itself.