Database Reference
In-Depth Information
3. Now, SSDT displays a squiggly line under the
EnglishPromotionType
column, and we must specify the name column property for any attribute
that has multiple key columns. Right-click on the ellipsis button next to the
NameColumn
property to activate the
NameColumn
dialog. Choose the
EnglishPromotionType
column and click on
OK
. At this point SSDT will re-
move the missing-name-column warning from the
EnglishPromotionType
attribute.
Note
In this example, we used a composite key for the promotion type attribute.
This practice is acceptable for relatively small dimensions, but if you're
working with large dimensions it is best to use narrow keys (meaning a
single column, preferably with an integer data type) for each attribute. It
Search WWH ::
Custom Search