As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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.
Posts: 176 | Location: Desplaines | Registered: August 05, 2004
--- 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. ---
Posts: 20 | Location: NY, NY | Registered: June 19, 2003