Modifying a Slowly Changing Dimension KM to allow undefined behaviors
When working with a slowly changing dimension, you may sometimes encounter a dimension table that has dozens (or perhaps hundreds) of attributes, making the task of setting the SCD behavior for each column very tiresome. There may also be occasions when business requirements dictate that all activity on a specific dimension table be captured historically, that is, all columns are considered to be the "trigger" fields.
In order to address these two situations, a few simple modifications can be made to the SCD IKM to allow the developer to avoid having to set the SCD behavior for every column. By making these simple modifications, the developer will only need to set the behaviors ...
Get Oracle Data Integrator 11g Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
