Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Slowly Changing Dimension

Status
Not open for further replies.
dsuser

dsuser

Technical User
Sep 9, 2003
2
US
Hi,

Can anyone explain how the different types of slowly changing dimension are implemented in a data warehouse design. And also how the implementation of surrogate keys differ according the type of SCD.
Can you talk about implementing surrogate keys in a Type 1 SCD on an Incremental Load.

Any help appreciated.

Thanks,
dsuser
 
Status
Not open for further replies.

Similar threads

Iamundercover
  • Locked
  • Question
need solution for IIel load late arriving dimension
Replies
6
Views
131
Iamundercover
Iamundercover
srjosyula
  • Locked
  • Question
Changing Target Directory in Informatica
Replies
3
Views
27
blom0344
blom0344
monsky
  • Locked
  • Question
Data Stage and Slowly Changing Dimensions
Replies
2
Views
22
johnherman
johnherman
djfinley
  • Locked
  • Question
Changing Compound Limit w/ Script
Replies
1
Views
25
djfinley
djfinley
MSIsam
  • Locked
  • Question
Changing order of Queries (8.2.1)
Replies
2
Views
25
MSIsam
MSIsam

Part and Inventory Search

Sponsor

Back
Top