dbTalk Databases Forums  

SCD in sql server 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SCD in sql server 2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Keshav via SQLMonster.com
 
Posts: n/a

Default SCD in sql server 2005 - 11-02-2005 , 01:56 AM






We can map current, start and end columns to SCD properties in SQL 2005. Does
this only server documentation / metedata purposes or does it actually effect
the way the cube is built?

thank you


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200511/1

Reply With Quote
  #2  
Old   
Norman P.
 
Posts: n/a

Default RE: SCD in sql server 2005 - 11-19-2005 , 01:37 PM






I have the same question. Is there any documentaion about what does once you
have set these attribute types. Is there something that needs to be done
differently in the ETL process as a result
--
Norman P.


"Keshav via SQLMonster.com" wrote:

Quote:
We can map current, start and end columns to SCD properties in SQL 2005. Does
this only server documentation / metedata purposes or does it actually effect
the way the cube is built?

thank you


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200511/1


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.