OraFAQ Forum: Data Integration » slowly changing dimensions

Home » Developer & Programmer » Data Integration » slowly changing dimensions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

slowly changing dimensions [message #178210]

Tue, 20 June 2006 02:35

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

Report message to a moderator

Re: slowly changing dimensions [message #178734 is a reply to message #178210]

Thu, 22 June 2006 06:40

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

Report message to a moderator

Re: slowly changing dimensions [message #179188 is a reply to message #178210]

Mon, 26 June 2006 04:44

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

Report message to a moderator

Re: slowly changing dimensions [message #191639 is a reply to message #178210]

Thu, 07 September 2006 07:22

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 ???

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 13 14:10:55 CDT 2024