Page 1 of 1
Data type
Posted: Tue Dec 02, 2008 4:49 pm
by cherry
Hi All,
I have a field defined as Float at the database level. When I import metadata using Datastage it is taking as Double. When I compare the source values with the target values there is a data mismatch. My datbase is Oracle 10g. Could some one help me how to resolve this issue.
The Data looks like this:
Source Data:0.5805555556
Data loaded as : 0.580555555600000051
Best Regards
Cherry
Posted: Wed Dec 03, 2008 7:31 am
by cherry
Could some one suggest me what to do
Best Regards
Cherry
Posted: Wed Dec 03, 2008 7:47 am
by mahadev.v
Dont push. People post only when they have a suggestion. Are you changing the data type to "Float" in DataStage? Did you try a direct mapping from Double to float?
Posted: Wed Dec 03, 2008 9:33 am
by cherry
I tried with loat as well. It gives implicit conversion warning
Regards
Cherry
Posted: Wed Dec 03, 2008 9:49 am
by mahadev.v
Hmm. Warning can be handled. But is the value getting loaded correctly. i had the same problem and direct mapping did the trick.
Posted: Wed Dec 03, 2008 10:05 am
by kandyshandy
After you imported the meta data into oracle stage, try manually changing Double type to Float.
Posted: Wed Dec 03, 2008 10:36 am
by cherry
I tried changing the data type from double to float, after changing the values looks like the following:
Source Value:0.5805555556
Target Value:0.580556
I have done the direct mapping, the value doesn't match. Please let me know.
Regards
Cherry
Posted: Wed Dec 03, 2008 10:41 am
by kandyshandy
Do you see any value as SCALE for that specific field in oracle stage?
Posted: Wed Dec 03, 2008 11:12 am
by cherry
I got it, I have converted the field to to_char and changed the data type to char.The value is matching now.
Thanks for your support
Regards
Cherry