For a slowly changing dimesion, say Customer, the ID is the business key, and Name SCD attribute.
SurrogateKey BusinessKey Name Current
1001 1 William 0
1002 1 Bill 1
Question: when do analysis, how Cognos decides which Name to show? I don't see settings for this in Framework Manager Project
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.