DSXchange

Thanks Ray,
By generating key column change column in sort stage could achieve this task.

Thanks Ray, I need to populate running totals for each category (like 10, 20, 30, 40......) and for each project (project_id's). Already I am using below logic to get running totals but I am not sure how could I add key column change to this. Could you please give a suggestion? Logic I am using in t...

Thanks Chulett, It was the problem with transformer stage option "sequential". I changed everywhere expect in transformer thats why I was getting errors. Now the thing is I am getting running totals for each code seperately but continously for all projects, but I want separate running tota...

I am getting running totals continuously. I want totals separately for each project. Can anyone suggest how can I achieve it? In detail Project_id----year----account_period----category----amount 1 2013 1 10 150 1 2013 1 20 280 1 2013 2 10 200 1 2013 2 20 450 2 2013 1 10 100 2 2013 1 20 520 2 2013 2 ...

I am getting running totals continuously. I want totals separately for each project. Can anyone suggest how can I achieve it?

Thank you,

I used "order by" clause in source query. Select .......... from ...... where .... group by project_id, accounting_period, category, category_name order by project_id, accounting_period, category, category_name In sort stage I am defining each one of the Project_id, accounting_period, cate...

Hi Chulett,
I am running it in sequential mode. I didn't enable partition reads and I selected sequential mode under transformer stage also.

Thanks,

There is a small problem. Finally summation (Running total) is working but it's not calculating in the order. I want to calculate running totals based on the month (accounting period column) 1 to 12. I am sorting at the source query and I tried sorting using sort stage also but it is calculating in ...

Sorry ArndW,
I missed it in that post.

Thank you,

Stage Variables are like this: TEMP1 - IF DSLink21.CAT='10' THEN TEMP1+DSLink21.BUDGET_AMOUNT ELSE TEMP1 TEMP2 - IF DSLink21.CAT='20' THEN TEMP2+DSLink21.BUDGET_AMOUNT ELSE TEMP2 .................. TEMP - if (DSLink21.CATEGORY='10') Then TEMP1 Else If (DSLink21.CATEGORY='20') Then TEMP2 Else TEMP3 I...

Hi ArndW,
I am getting all zero's in cumulative column. Could you please guide me?

Thank you,

Regards,
Lohith Sama.

Use stage variable to remember the earlier row and to generate the running total. Make it the same data type as the output column, which must be compatible with the data type of Amount. Initialize t ... Thanks Ray, I already tried that I am getting 0's and 1's that I didn't understand. It was worki...

Hi, I am working on a task to calculate cumulative (running totals) of a column based on another column (code). Example: s.no code amount 1 10 100 2 20 150 3 10 50 4 10 150 5 20 30 Output s.no code amount cumulative 1 10 100 100 2 20 150 160 3 10 50 150 (100+50) 4 10 150 300 (150+150) 5 20 30 190 (1...

I partitioned source table using Rowid range under Oracle connector. But the thing is I can't able to enable bulk load under target oracle connector. How can I use bulk load ?

Thanks,

Thanks Prasson,
I haven't used partition in source tables. Is it possible for you to throw some light on me.

Thank you,