cancel
Showing results for 
Search instead for 
Did you mean: 
oabdelkarim
Employee
Employee
Status: New

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.

1 Comment
dylanwan
Employee
Employee

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