DSXchange

I also faced the same issue. Below 2 points made my job successfully finish without any warnings: 1) My file should follow the below format. Instead of Case2, follow Case1: Case 1 ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB | Case 2 ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB ABCTTTAAAABBB...

Yes. That is a part of formula that needs to be applied in the expression.

Hi Ray,
Those constant values were just to illustrate my example. However, my expression has a datatype defined as decimal(38,10):

pwr((1+DSLink.Percent/100),(DSLink.Period/12)) -1

Thanks!

I have my datatype defined as decimal(38,10) only.. so that is not being treated as Integer.

Hi Rodriguez, I verified the datatypes and they are correctly set. Similarly, the parenthesis imposed are correct. Hi UCDI, If I consider the hard coded example as ((1+(-2)/100)^(1/12)-1), expected result is -0.001682143. However, in DS, when I use the PWR function, I am always getting value as 1 (b...

Hi Craig,
Please ignore "*100" on the RHS.. that was just to show case one example that I actually needed..


Hi UCDI,
It's not a negative number.. if you manually resolve that value, it'll end up being:

((98/100)^(1/12))-1

Pls note the parenthesis in the above example.

Thanks!

Can someone please help me with this?

Hi All, I am trying to use power function (pwr)in stage variable.. However, I am unable to achieve my result set in my parallel job. Below is the expression that I need to use in my derivation. Just for your information, below derivation works properly fine when I run the formula in Excel sheet with...

Hi Craig and qt_ky, Thanks for your inputs. I can execute those commands through Toad. And I confirmed with my DBA too, I have grants too. Not sure, what is causing the error. To keep my work going, I have created a Unix script to refresh my view which I am calling in my After Job sub-routine. Thank...

I searched a lot on this forum but no luck for my solution. I am calling below script in my AFTER Sql to refresh my Materialized view but it is failing. I already tried below options: 1) EXEC DBMS_MVIEW.REFRESH('ABC', atomic_refresh => false,out_of_place => true); Error: ORA-00900: invalid SQL state...

I got a work around by calling my procedures through Oracle connector stage.

Thanks for the input. Now I am using metadata as the input to the SP stage.
However, can you please tell me how parameters are bind/mapped into the PARAMETERS tab? Does the properties that I mentioned in the PARAMETERS tab looks good?
Appreciate your help in this.

Hi, I have an Oracle procedure which I am invoking in DataStage. This procedure accepts one parameter from my ETL job and loads my target table. I am finding it difficult to map parameter in the Parameters tab. Below is my simple job design: Row Generator Stage --> Stored Procedure Stage. Below are ...

Can anyone explain the reason behind this?
It worked for me too..

Craig, It should get rounded to "2000.3". As of now, I am using two transformer stages to achieve my end result. Step 1) Converting varchar2(25) to Decimal(20,1) using syntax: StringToDecimal(2000.29). Step 2) Convering Decimal(20,1) to varchar2(25) using syntax: DecimalToString(2000.3,&qu...