How to handle slowly changing dimension (type2) in iWay.
You really can't answer this question unless you see the ETL design. One major problem with iway ETL manager is that it does not allow update/inserts to a table if it is also a source.
One thing that you generally do is, join your staging dimension table to the warehouse tables and identify the changes. In one pass you will have to update the old row with an end date and in the second pass insert the new row.
This is from the product manager:
The answer to how do we handle type 2 dimensions is that in release 71 it's built into the product. You designate which columns in the table require type 2 handling, and whether to use activation dates or activation flag, and we handle the rest.
|Powered by Social Strata|