Data type

cherry · Post by **cherry** » Tue Dec 02, 2008 4:49 pm

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

cherry · Post by **cherry** » Wed Dec 03, 2008 7:31 am

Could some one suggest me what to do

Best Regards
Cherry

mahadev.v · Post by **mahadev.v** » Wed Dec 03, 2008 7:47 am

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?

cherry · Post by **cherry** » Wed Dec 03, 2008 9:33 am

I tried with loat as well. It gives implicit conversion warning

Regards
Cherry

mahadev.v · Post by **mahadev.v** » Wed Dec 03, 2008 9:49 am

Hmm. Warning can be handled. But is the value getting loaded correctly. i had the same problem and direct mapping did the trick.

kandyshandy · Post by **kandyshandy** » Wed Dec 03, 2008 10:05 am

After you imported the meta data into oracle stage, try manually changing Double type to Float.

cherry · Post by **cherry** » Wed Dec 03, 2008 10:36 am

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

kandyshandy · Post by **kandyshandy** » Wed Dec 03, 2008 10:41 am

Do you see any value as SCALE for that specific field in oracle stage?

cherry · Post by **cherry** » Wed Dec 03, 2008 11:12 am

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