join different data type
Posted: Wed Feb 03, 2010 4:34 am
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.
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.