Home » Developer & Programmer » Data Integration » slowly changing dimensions
slowly changing dimensions [message #178210] Tue, 20 June 2006 02:35 Go to next message
coolbee_chinna
Messages: 7
Registered: June 2006
Junior Member
hi all...
can u tell me that exact definition of slowly changing dimensions..
thanks in advance
babu.A
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
Ferrarist
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.

Regards,
Rob
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
Ashokragauv
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.

Regards
Ashok
Re: slowly changing dimensions [message #191639 is a reply to message #178210] Thu, 07 September 2006 07:22 Go to previous message
faseeur_r
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: Fri Mar 29 06:17:54 CDT 2024