Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    slowly changing dimension
Go
New
Search
Notify
Tools
Reply
  
slowly changing dimension
 Login/Join
 
<Renuka>
posted
How to handle slowly changing dimension (type2) in iWay.
 
Reply With QuoteReport 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, 2004Reply With QuoteReport 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, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.