All,
I was trying to understand the perpose of putting logical Keys on the DSV, I have read articles and book saying that we should use/set them, but since they don't create the Keys at teh database level I was wondering how this helps? Is this just to aide the various Wizards?
Regards,
Yes, they are mainly to help the various wizards. It helps the dimension wizard identify dimesion keys and the cube wizard can use them to help identify the roles (fact/dimension) that the particular tables are playing. Strictly speaking you can get away without using them and set the relevant properties in the dimensions and cubes yourself. These keys have no effect on performance.
No comments:
Post a Comment