Skip to Content

Value is round when load data form source to target table

Hi All,

I am facing a different issue when I am working on support environment.

Here I am proving example

My Source ( Oracle Table)

---------------------------------

Qty, Exchange_Rate, Bill_Rate

17.5, 6869.5, 934.36

when I load this data into target values are rounding, such as

My Target ( Oracle Table)

----------------------------------

Qty, Exchange_Rate, Bill_Rate

18, 6870, 934

How to solve this issue please guide me it is very urgent issue .

Thanks and Regards,

Murali

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 10, 2016 at 09:55 AM

    Hi @Murali Krishna,

    What is the data type for the target table fields. if it is integer when you are trying to load any decimal values in the integer it will happen. Change the Integer to Decimal(p,s)

    If the data type of is still decimal and you are facing this issue. Then you need to try adding it explicitly to_decimal(Column Name , 'Decimal Separator','Thousand Separator', Scale as int) function.


    Example:


    Regards,

    Akhilesh Kiran.


    pastedImage_4.png (13.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Akhilesh Kiran

      Hi murali,

      you should follow my procedure

      observe the document i am sharing

      if you have any queries ask me

      suppose if your dout is clear please mention

      thank you

      OBSERVE THE SOURCE AND TARGETA:AFTER RUNING THE JOB HOW TARGET LOOK

      STEP1:DESIGN THE SOURCE FIRST

      STEP2: WATCH THE SOURCE DATA

      STEP 3:A:QUERY MAPPING AND LOGIC IMPLEMENTAION: FOR QTY: ROUND(MURALI_SRC.QTY,0)

      STEP3:B:QUERY MAPPING AND LOGIC IMPLEMENTAION:EXCHANGE_RATE: round( MURALI_SRC.EXCHANGE_RATE,0)

      STEP3:B:QUERY MAPPING AND LOGIC IMPLEMENTAION: BILL_RATE: round( MURALI_SRC.BILL_RATE,0)

      STEP4:EXCUTE THE JOB

      STEP:5 RESULT AFTER RUN

      murali if you need documentation for this please mail me : mahi.analytics@gmail.com

      Message was edited by: mahesh chinnala