Hi
I have a col which is coming as integer in the input and the same col in reference is defined as decimal. When i join source and reference using this column as the key, what will be the situation. should it join or should it not join.
The value from souce is 10
The value from target is 10.00
For some of the records it is joining, and for some it is not joining. I didnt change the datatype either from source or reference, but want to know whether i need to handle this using a function and then use this as a key for join.
join different data type
Moderators: chulett, rschirm, roy
It always advisable to make datatype identical for JOIN. Change any of your column datatype (either Source or Reference) and then perform JOIN operation
Last edited by abhijain on Mon Feb 08, 2010 4:13 am, edited 2 times in total.
Rgrds,
Abhi
Abhi