DSXchange

Hi Kunal,

I have done temporary fix as rejecting these records to reject table which are not fitting to Target Decimal(14,2).

Hi Ray,

When i use decimalToDecimal(Incol,'floor') i get warning in target as
and the value is becoming 0.00

Hi Srini, If i define Decimla(14,2) in source metadata i get below error:- ORA_READ_TABLE,0: Fatal Error: APT_Decimal::assignFromString: the source string (-20567940872210.497284.46) is out of range for the decimal with precision 14. So i have to increase precision for this column and handle somewhe...

Hi,

If the value is not decimal,i need to reject those records.

Hi, 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 :- SELECT Round(Chain_Intake_Cost,2) As Chain_Intake_Cost 'X' As Dummy From Table And i have defined Chain_Intake_Cost column as Decimal(25,2) in source metadata. But when pr...

Hi,
Can someone help me to above issue.

Pivot stage is working perfectly, but it does not know that your output should be based on month value. You can use transformer and create 26 stage variables and initialize 0. For ex: Julyrev=if month=7 then rev else julyrev Julyvol=if month=7 then vol else julyvol ................. Pass these varia...

Hi
Decimal is not a valid integer, then how come you are getting 'Y' for decimals
If you are in 8.x version then it may be due to datastage Behaving differently in 8.1 or 8.5 .
check below link.



http://www-01.ibm.com/support/docview.w ... wg1JR39651

Hi,
You can set auto purge option in director.you can set either based on number of previous run or no of days .

Check this link

http://www-01.ibm.com/support/docview.w ... wg21511794

Hi Chullet,
I tried to test IsValidDecimal ("prasoon") and it gave output as 1.

Hi,
I already tried this but it does not work..

Hi,

Ok,then how can we validate if input is varchar and target is decimal.

Hi, I am trying to check IsValidDecimal functionality in Datasatage 8.7. I have developed simple job for this. RowGen------> TSFM-------> Peek In Transformer i generated Two columns and assigned below value. COL1=IsValidDecimal(StringToDecimal("20368.5")) COL2=IsValidDecimal(StringToDecima...

Hi,
Do you have proper privilage to run the SP in QA.