Create star schema based on multiple dimension
up vote
0
down vote
favorite
1
Based on the diagram attached it is possible to create a classical star schema (Kimball) having the Sales as fact table?
Thank you
]1
ssis etl data-warehouse star-schema snowflake-schema
asked Nov 8 at 23:53
Sandu Catalin
132
add a comment |
up vote
0
down vote
favorite
1
Based on the diagram attached it is possible to create a classical star schema (Kimball) having the Sales as fact table?
Thank you]1
ssis etl data-warehouse star-schema snowflake-schema
asked Nov 8 at 23:53
Sandu Catalin
132
2
Short answer: Yes. Medium Answer: Just combine your lookup tables into a two denormalised dimensions: Customer and Product. Long answer: Do you want to preserve the sales channel that the produce was sold through at the time it was sold?
– Nick.McDermaid
Nov 9 at 1:09
add a comment |
up vote
0
down vote
favorite
1
up vote
0
down vote
favorite
1
1
Based on the diagram attached it is possible to create a classical star schema (Kimball) having the Sales as fact table?
Thank you]1
ssis etl data-warehouse star-schema snowflake-schema
asked Nov 8 at 23:53
Sandu Catalin
132
Based on the diagram attached it is possible to create a classical star schema (Kimball) having the Sales as fact table?
Thank you]1
ssis etl data-warehouse star-schema snowflake-schema
ssis etl data-warehouse star-schema snowflake-schema
asked Nov 8 at 23:53
Sandu Catalin
132
asked Nov 8 at 23:53
Sandu Catalin
132
asked Nov 8 at 23:53
Sandu Catalin
132
asked Nov 8 at 23:53
Sandu Catalin
132
asked Nov 8 at 23:53
Sandu Catalin
132
132
2
Short answer: Yes. Medium Answer: Just combine your lookup tables into a two denormalised dimensions: Customer and Product. Long answer: Do you want to preserve the sales channel that the produce was sold through at the time it was sold?
– Nick.McDermaid
Nov 9 at 1:09
add a comment |
2
Short answer: Yes. Medium Answer: Just combine your lookup tables into a two denormalised dimensions: Customer and Product. Long answer: Do you want to preserve the sales channel that the produce was sold through at the time it was sold?
– Nick.McDermaid
Nov 9 at 1:09
2
2
Short answer: Yes. Medium Answer: Just combine your lookup tables into a two denormalised dimensions: Customer and Product. Long answer: Do you want to preserve the sales channel that the produce was sold through at the time it was sold?
– Nick.McDermaid
Nov 9 at 1:09
Short answer: Yes. Medium Answer: Just combine your lookup tables into a two denormalised dimensions: Customer and Product. Long answer: Do you want to preserve the sales channel that the produce was sold through at the time it was sold?
– Nick.McDermaid
Nov 9 at 1:09
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53217887%2fcreate-star-schema-based-on-multiple-dimension%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Short answer: Yes. Medium Answer: Just combine your lookup tables into a two denormalised dimensions: Customer and Product. Long answer: Do you want to preserve the sales channel that the produce was sold through at the time it was sold?
– Nick.McDermaid
Nov 9 at 1:09