May 03, 2005, 06:24 AM<Renuka>
slowly changing dimension
How to handle slowly changing dimension (type2) in iWay.
May 06, 2005, 06:58 PMnewtofocus
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.
May 06, 2005, 07:26 PMJake Freivald
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.