How to convert pivot column structure to dimension table
I want to convert a table structure with pivoted columns into a dimension table and fact table.
how to create a medication dimension table from the data with below structure with model enforcing star schema
data-warehouse dimensional-modeling star-schema snowflake-datawarehouse snowflake-schema
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
add a comment |
I want to convert a table structure with pivoted columns into a dimension table and fact table.
how to create a medication dimension table from the data with below structure with model enforcing star schema
data-warehouse dimensional-modeling star-schema snowflake-datawarehouse snowflake-schema
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
Can you please clarify what is the exact output that you're expecting? It's not clear, and various options are possible.
– Marcin Zukowski
Jan 2 at 18:36
add a comment |
I want to convert a table structure with pivoted columns into a dimension table and fact table.
how to create a medication dimension table from the data with below structure with model enforcing star schema
data-warehouse dimensional-modeling star-schema snowflake-datawarehouse snowflake-schema
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
I want to convert a table structure with pivoted columns into a dimension table and fact table.
how to create a medication dimension table from the data with below structure with model enforcing star schema
data-warehouse dimensional-modeling star-schema snowflake-datawarehouse snowflake-schema
data-warehouse dimensional-modeling star-schema snowflake-datawarehouse snowflake-schema
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
asked Jan 2 at 2:57
krishna chaitanyakrishna chaitanya
113
113
Can you please clarify what is the exact output that you're expecting? It's not clear, and various options are possible.
– Marcin Zukowski
Jan 2 at 18:36
add a comment |
Can you please clarify what is the exact output that you're expecting? It's not clear, and various options are possible.
– Marcin Zukowski
Jan 2 at 18:36
Can you please clarify what is the exact output that you're expecting? It's not clear, and various options are possible.
– Marcin Zukowski
Jan 2 at 18:36
Can you please clarify what is the exact output that you're expecting? It's not clear, and various options are possible.
– Marcin Zukowski
Jan 2 at 18:36
add a comment |
1 Answer
1
active
oldest
votes
For some reason I cannot see the picture you uploaded to show data structure. I am assuming that you want to create a relationship between a medicine dim and a patient. If this is true then you need a bridge table between your medicine and your Fact table. The bridge table should have one row per patient ID and a specific medicine ID. That means if a patient is taking 4 medicine then there are 4 rows in the bridge table for same patient ID but different medicine ID. A patient ID should exist in the Fact table for a day so when Fact is join with the bridge table it shows all the medicine that patient is taking.
answered Feb 22 at 13:51
Sam KazSam Kaz
71
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f54000742%2fhow-to-convert-pivot-column-structure-to-dimension-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
For some reason I cannot see the picture you uploaded to show data structure. I am assuming that you want to create a relationship between a medicine dim and a patient. If this is true then you need a bridge table between your medicine and your Fact table. The bridge table should have one row per patient ID and a specific medicine ID. That means if a patient is taking 4 medicine then there are 4 rows in the bridge table for same patient ID but different medicine ID. A patient ID should exist in the Fact table for a day so when Fact is join with the bridge table it shows all the medicine that patient is taking.
answered Feb 22 at 13:51
Sam KazSam Kaz
71
add a comment |
For some reason I cannot see the picture you uploaded to show data structure. I am assuming that you want to create a relationship between a medicine dim and a patient. If this is true then you need a bridge table between your medicine and your Fact table. The bridge table should have one row per patient ID and a specific medicine ID. That means if a patient is taking 4 medicine then there are 4 rows in the bridge table for same patient ID but different medicine ID. A patient ID should exist in the Fact table for a day so when Fact is join with the bridge table it shows all the medicine that patient is taking.
answered Feb 22 at 13:51
Sam KazSam Kaz
71
add a comment |
For some reason I cannot see the picture you uploaded to show data structure. I am assuming that you want to create a relationship between a medicine dim and a patient. If this is true then you need a bridge table between your medicine and your Fact table. The bridge table should have one row per patient ID and a specific medicine ID. That means if a patient is taking 4 medicine then there are 4 rows in the bridge table for same patient ID but different medicine ID. A patient ID should exist in the Fact table for a day so when Fact is join with the bridge table it shows all the medicine that patient is taking.
answered Feb 22 at 13:51
Sam KazSam Kaz
71
For some reason I cannot see the picture you uploaded to show data structure. I am assuming that you want to create a relationship between a medicine dim and a patient. If this is true then you need a bridge table between your medicine and your Fact table. The bridge table should have one row per patient ID and a specific medicine ID. That means if a patient is taking 4 medicine then there are 4 rows in the bridge table for same patient ID but different medicine ID. A patient ID should exist in the Fact table for a day so when Fact is join with the bridge table it shows all the medicine that patient is taking.
answered Feb 22 at 13:51
Sam KazSam Kaz
71
answered Feb 22 at 13:51
Sam KazSam Kaz
71
answered Feb 22 at 13:51
Sam KazSam Kaz
71
answered Feb 22 at 13:51
Sam KazSam Kaz
71
71
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2f54000742%2fhow-to-convert-pivot-column-structure-to-dimension-table%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
Can you please clarify what is the exact output that you're expecting? It's not clear, and various options are possible.
– Marcin Zukowski
Jan 2 at 18:36