We are going to use DMC version 81M. As database we are running DB2 z/Os version 11. A DB2 adapter is installed. Been reading about SCD in the DMC manual, but have a few questions.
We have an actual table in which the current situation is stored, of agreements And we have a history table that stores all the changes. Using begin-date, end-date and a recent-indicator. When I take all the rows in the history table with recent-indicator = Y, I have the same rwos as in the actual table. When a change comes in the actual table, the history has to be updated using SCD.
When using SCD in Data Management Console: - must I indicate in the master of the history table whether a column is SCD-type 1 or 2? - must i install a log table for the actual or history table when using SCD? - must the columnames in both masters be identical? - we are using DB2 identity key as surrogate key, so generated by DB2. Is this ok, or wants Datamigrator assign values?
Hope someone can clarify
Thnx a lot RonThis message has been edited. Last edited by: FP Mod Chuck,