on 04-10-2016 6:56 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.