DSXchange

I chekced return type of SUM funcation. it is takeing as decimal(18,2).

could you please let me know what basis it is takeing as decimal(18,2).

Hi, my job td stage ----> trans-----> tdstage. I have written custom query in the teradata connector stage(source). select sum(reslt_1) from table group by master_trim_id. result_1 decimal(16,2). BUT job is failed. it is expexting decimal(18,2) after useing cast function my job is running fine, sele...

Thanks jwiles.

I think no need to use any function since already I have calender table's which I mentioned above.

Please correct me I am worng

Please help me

Hi, I need to calculate week in month no by useing below condition. count(WEND) from D_CM_ACCT_CAL where D_CM_ACCT_CAL_DAY.WEND = D_CM_ACCT_CAL.WEND and D_CM_ACCT_CAL_DAY.PERIOD = D_CM_ACCT_CAL.PERIOD D_CM_ACCT_CAL(Table by Week),D_CM_ACCT_CAL_DAY(Table by month) are calender tables. D_CM_ACCT_CAL (...

Thanks for ur solution


Regards,
Srini

This is the compilation error.




when ever n_Xfm_2.MO_NBR= 07 this condition iam getting compilation error

Hi, I want to implement the following oracle function in DS Transformer. The oracle function is ---- decode(MO_NBR,01 through 09,Fyear +0, 10 through 12, Fyear +1) While i implement this function as --- if (in_Xfm_2.MO_NBR =01 or in_Xfm_2.MO_NBR= 02 or in_Xfm_2.MO_NBR=03 or in_Xfm_2.MO_NBR= 04 or in...

Hi, when i implement the following oracle function in DS Transformer level i am getting the following error message. the oracle function is ----period||trim(to_char(week_in_mn,'0')) . here the datatype of period ,week_in_mn is decimal and double respectively. i have used the following function in tr...

Hi,

I want to sum of more than one input column in same output column by useing Aggregator stage.

ex: select sum(col1+ col2) group by col3.

Please help me.

example

input:
col1
a
b
c
d
e
f

output:
col1 col2
a 6
b 6
c 6
d 6
e 6
f 6

please help me

Sorry Kryt0n I will explain my requirement clearly. job design-> td stage -> transformer-> td stage in source I have written custom query. From this query I am extracting one column(period). I want count of this column. For this I want to use loop variable. I hope you will get my requirement.

this is the requirement. This is the first time iam implementing by useing loop variable.I am trying to give lastrow(col1).but it is not allowing. Please let me know where I am doing wrong

Hi, I want to caclulate count of the column by useing loop variables in transformer. select count(col1) from the table. But i am getting 5000 rows out of 10000. Defined the following stage variables: NumSavedRows SaveInputRecord() IsBreak LastRow() NumRows IF IsBreak THEN NumSavedRows ELSE 0 Defined...

Hi ray,

in terms of performence.

and also could you plesae explain what is difference between three approches.