how to Store number of records fetched in incremental load in table?

[gauravgg]

hi

in have created incremental load script for five tables

i want to store number of new records fetched in table as follows

Table Name	Rows before incremental load	New Rows fetched	Total Rows
TableA	100	5	105
TableB	500	60	560
TableC	1000	100	1100

i also want date time field in the above table

so that i can track how many new mew records are fetched and on which date

thanks in advance

[sunny_talwar]

Might be easier to help if you can share your script.