Need of ROWNUM
==============

Here in dTable i need ROWNUM for running number (record_id) column of dTable, which is my primary key.
also dTable is partitioned by range using this record_id column.
To genrate this running number i am using ROWNUM into select query of sTable.