Value is round when load data form source to target table

[former_member241220]

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

[akhileshkiran · Accepted solution]

Hi

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.

[former_member241220 · Accepted solution]

Hi Akhilesh Kiran,

Thanks your swift reply.

In my target able I am having number datatype, and our target is Oracle database.

Thanks and Regards,

Murali

[akhileshkiran · Accepted solution]

Hi

You can use to_decimal function as i mentioned above and change the data type to decimal in the query level of the particular columns.

Please close the thread by marking it as Helpful or Answered.

Regards,

Akhilesh Kiran.

[Former Member · Accepted solution]

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