sql server data warehouse: Hi,

Currently, I'm working on a SQL Server DWH.
I work on a snowflake Schema. Let say that I've on product table wich is
linked using a FK on a product grouping key to a product group label.
If I update my product refrential, this works but ...
in the real life, if a new product appears and if this grouping code doesn't
existing my loading fails.

Do you have any idea/tricks in order to load the into the product
referential adding dynamicly a new key into the grouping referential
(setting product group to a defalut value)

thk's in advance,

Renaud Harduin
Paris - France

[quoted text, click to view]

Default is the only way to solve this issue (other than properly
determining a product group at import time, which would be preferable).
Create an "Unknown" default group and set that as the default on your group
FK column.

Thk's

Renaud Harduin

"Adam Machanic" <amachanic@air-worldwide.nospamallowed.com> a écrit dans le
message de news:OYhbvx%23JEHA.2704@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]