Creating an insert/update date using transformation - how to keep that data during a reload
I would like to create an insert/update date column in my target table.
I know I would be using a transformation for this - however I don’t want to lose the data in that insert/update date column when a table is reloaded. The normal behavior for that is the date gets replaced for every record that is reloaded
does anyone know a way around this? The insert/update date column is going to be used for an incremental data load into our data warehouse. In the event that we have to reload the table, all the data would have to be reloaded in the data warehouse based on the date being changed, which is not ideal for us. Anyone have any ideas that Qlik can help us meet that requirement without changing the source table?
we are using sql server MS-CDC, which usually requires us to reload tables when a table level DDL change is done.
As to how to preserve this date when you do a table reload I am not aware of any task setting that would accomplish this.
One thing I can think of from outside of replicate would be to to make a copy of the table before reload from task - then after the reload have a script that would update the new table rows with the original insert dates from the copied table.
