We have 2 columns in the source table EVENT_ID,EVENT_DATE
The records are as follows:
EVENT_ID EVENT_DATE
1,27-MAR-08
1,27-MAR-08
1,27-MAR-08
2,27-MAR-08
2,27-MAR-08
Now we want to populate target table with one more exract column which is nothing but transaction number(number of transactions done)..means number of occurance of EVENT_ID.
that is we want to generate number as:
EVENT_ID EVENT_DATE TRANSACTION_DONE
1,27-MAR-08,1
1,27-MAR-08,2
1,27-MAR-08,3
2,27-MAR-08,1
2,27-MAR-08,2
Means in all 3 transactions are done by EVENT_ID 1.We want to store all these three numbers.
Now my question is how can we generate TRANSACTION_DONE column?
In our job we are using sort and transfomer stage.
Thanks !
![Exclamation :!:](./images/smilies/icon_exclaim.gif)