Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Might be easier to help if you can share your script.