I have source as Oracle and Target is Oracle.In my source dataype is Number and target is Number(14,2)
My select query is :-
Code: Select all
SELECT
Round(Chain_Intake_Cost,2) As Chain_Intake_Cost
'X' As Dummy
From Table
But when precision for column is coming more then 14 that particulat record is getting dropped in Transformer with warning message.
Is there any way i can convert Decimal(25,2) to decimal(14,2) in transformer stage.