Cursor logic in Datastage

[mekrreddy]

Hello all,

I have a requirement, where i need to loop the records against single record.

Table.

Student Sub
1 Math
1 Eng
1 Sci
2 Math
2 Eng
3 Math
3 Eng
3 Sci
3 Dra

Our output should be something like this

1- 1 1 1 0
2- 1 1 0 0
3- 1 1 1 1

1 says student has that subject 0 says he does not have.

Input is oracle table, Out put can be a text file.

Any ideas please ..

Thanks in advance..
reddy

[chulett]

No 'cursor' or 'loop' needed, just looks like an aggregation to me.