Database Software

I'm trying to incorporate the use of ROWNUM as part of my sql logic in OWB. I've attempted to add ROWNUM to a table in my mapping so I could reference the column. There is an option in the Column Usage when you pull up the attribute list on the Input/Output tab of the table editor. You have a choice of Table Column, ROWID, and ROWNUM. I've created an attribute on the table called ROW_NUM and selected ROWNUM as my column usage. I generated and deployed the mapping. However, when I look at the data viewer in the mapping editor, the rownum is not populated. I had expected OWB to generate the rownum on the table.

Any suggestions on how I can get this to work? I wanted to reference ROWNUM in a filter to filter out a range of rows for sample updating.

If this isn't going to work, I could just put a sequence on the table and instead of using ROWNUM logic, but now I'm curious why this doesn't work?!!

I'm using OWB 10.2

Thanks,
Sabert