How to handle nested loop ?

[kiabathe]

Loop alll the years, months records and match the code from another table
then retrive the data with the sum of calculation.
I could use agrigate stage to sum up but how do I loop it so, it will hold the values just like a cursor in pl/sql.
In simple way how to do a nested loop in DataStage?

Thanks in advance,

 

[tempra]

Hey mate, to accomplish this I would create a view that does the tables joins and totalizes the totals. The aggregations inside of ds are very slow.

Cheers,