How to get modification time of a table ??

[nikhilgarg]

Hey,

TO use incremental load for newly added rows how can i get modification time of table ?? So that i can compare it with LAst Execution Time of table and get the updated results or newly added rows  only.

Please help.

Thanx.

[nikhilgarg]

HEy,

If i replace Start date with modified date then the database will be incorrect.

THe Start date value will be overridden by Modified date.

Wat say ??