Accessing increments from source table

[oabdelkarim]

I want to be able to process an increment from a source table in an MV. Currently, I need to have some timestamp column in the source table to get the increment from it. I need an automated timestamp in the source tables (specially for those without predefined timestamp column) to filter on when retrieving the increment.

[dylanwan]

For SQL based source tables, the workaround is to add a column that is based on the current time function from the source database.

For example, if you are using Oracle database, you can do the following:

SELECT COL1
,      COL2
,      sysdate as DH_UPDATE_TIME
FROM   SCHEMA1.TABLE1