Numeric values are not correctly loaded into target

dataservices job design
1

We execute a job that contains a DF with 11 basic parallel flows.
This job is designed to load data into an ODS (no transfo).

Symptom :
Some target numeric values appear truncated

Workaround tried :
We have serialized the basic flows and fewer numeric
values appear truncated. The problem is not solved anyway.

Params : DOP=3

IT background
Source : Oracle 10G encodage UTF-8
Cible : MySQL 5.0
Job Server 11.7.3.6

funkyman72 (BOB member since 2009-01-27)

2

Are the precisions different in the query transforms? Please explain with examples and screenshots to help us understand the issue better.

chiamala (BOB member since 2008-12-26)

3

Are you implementing any int/int calculations and also check for implicit datatype conversions and also datatypes and their precessions in all query transforms starting from source to Target.

kumar.siva99 (BOB member since 2007-09-25)

4

hi,

thank you for reply.
There are no precision difference between source and target

funkyman72 (BOB member since 2009-01-27)

5

Could be a number of things. If you run just one of the flows that is causing problems, does it go away?

If not, you may have to post the ATL to get further assistance.

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)

6

hello yes we have the same problems with truncating…seems to be a bug in BODI.

I think this bug is caused when I use IFTHENELSE() inside of a query (attribute mapping)

when I have a ifthenelse clause with a double attribute inside of ifthenelse clause and a decimal28,7variable in the condition, then BODI truncates also the values inside of the variables of the ifthenelse-clause.

ifthenelse(decimal28,7-variable, double, double)

boximaster (BOB member since 2008-05-26)