data warehouse question?

asmaa

DW Fresher

Reputation: +0/-0
Offline

Offline

Posts: 1

data warehouse question?

« on: December 20, 2009, 05:49:27 pm »

hello everybody,
if i have customer data in data warehouse and that is customer was single,and then i want to update this data when the customer becomes married,
does i can make update in data warehouse or add a new recod with the new data about the customer?
i read that the data warehouse is non volatile and no update in it.

thanks in advance,
asmaa


	Logged

Sipra

Founder

Reputation: +59/-0
Offline

Offline

Posts: 323

Am the King...

SCD Approach for maintaining History

« Reply #1 on: December 20, 2009, 10:08:57 pm »

Quote from: asmaa on December 20, 2009, 05:49:27 pm

if i have customer data in data warehouse and that is customer was single,and then i want to update this data when the customer becomes married,
does i can make update in data warehouse or add a new recod with the new data about the customer?
i read that the data warehouse is non volatile and no update in it.

For this scenario, Based on End-user/Client agreement (or) as per the Business Approach; you can apply SCD (Slowly Changing Dimensions) to achieve the above.

For more info on SCD, refer this link.


	Logged

Sipra
Founder

www.dwforum.net

ragjeevan

DW Fresher

Reputation: +1/-0
Offline

Offline

Posts: 15

Re: data warehouse question?

« Reply #2 on: February 18, 2010, 01:23:05 pm »

Data warehouses are not necessarily no-volatile and undergo changes.The point to be stressed upon is that they are not as volatile as real-time Data Stores or OLTPs which can undergo changes frequently


	Logged

Pages: [1] Go Up

« previous next »