Home » Developer & Programmer » Warehouse Builder » slowly changing dimensions
slowly changing dimensions [message #178210] Tue, 20 June 2006 02:35 Go to next message
Messages: 7
Registered: June 2006
Junior Member
hi all...
can u tell me that exact definition of slowly changing dimensions..
thanks in advance
Re: slowly changing dimensions [message #178734 is a reply to message #178210] Thu, 22 June 2006 06:40 Go to previous messageGo to next message
Messages: 29
Registered: March 2006
Location: Netherlands - Den Haag
Junior Member
A slowly changing dimension is a dimension which's attributes can change over time.

If you want to know more (and there is quite a lot more Laughing), please google on it. You'll find plenty.

Re: slowly changing dimensions [message #179188 is a reply to message #178210] Mon, 26 June 2006 04:44 Go to previous messageGo to next message
Messages: 13
Registered: June 2006
Location: Pune
Junior Member

hi babu,

Slowly Changing Dimensions

This applies to cases where the attribute for a record varies over time.

There are in general three ways to solve this type of problem, and they are categorized as follows:

Type 1: The new record replaces the original record. No trace of the old record exists.

Type 2: A new record is added into the customer dimension table. Therefore, the customer is treated essentially as two people.

Type 3: The original record is modified to reflect the change.

Re: slowly changing dimensions [message #191639 is a reply to message #178210] Thu, 07 September 2006 07:22 Go to previous message
Messages: 1
Registered: September 2006
Junior Member
Can anybody tell me if its possible to do a Slowly changing dimensions in OWB..i know informatica has a SCD wizard but does OWB have one ???
Previous Topic: RPE-01008: Recovery of this request is in progress--while a table deploymen
Next Topic: altering mapping of a dimension, tabledata is only merging
Goto Forum:

Current Time: Sat Oct 10 02:44:00 CDT 2015

Total time taken to generate the page: 0.07322 seconds