Focal Point Banner


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 myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    slowly changing dimension

Read-Only Read-Only Topic
Go
Search
Notify
Tools
slowly changing dimension
 Login/Join
 
<Renuka>
posted
How to handle slowly changing dimension (type2) in iWay.
 
Report This Post
Platinum Member
posted Hide Post
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, 2004Report This Post
Member
posted Hide Post
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.
---

Regards,
Jake
 
Posts: 20 | Location: NY, NY | Registered: June 19, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    slowly changing dimension

Copyright © 1996-2020 Information Builders