Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
cherry
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
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
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
Post
by cherry » Wed Dec 03, 2008 7:31 am
Could some one suggest me what to do
Best Regards
Cherry
mahadev.v
Participant
Posts: 111 Joined: Tue May 06, 2008 5:29 am
Location: Bangalore
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?
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
cherry
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
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
Participant
Posts: 111 Joined: Tue May 06, 2008 5:29 am
Location: Bangalore
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.
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
kandyshandy
Participant
Posts: 597 Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore
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.
Kandy
_________________
Try and Try again…You will succeed atlast!!
cherry
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
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
Participant
Posts: 597 Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore
Post
by kandyshandy » Wed Dec 03, 2008 10:41 am
Do you see any value as SCALE for that specific field in oracle stage?
Kandy
_________________
Try and Try again…You will succeed atlast!!
cherry
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
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