Mixing
Explain the purpose of three areas of ETL, Source, Staging and Presentation and what data they contain
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I have to know the about the three areas (source, staging and presentation), the type of data they contain and their purpose but cant seem to find much information about the data that they contain.
I am hoping that someone of the stack overflow community will be able to help me
database etl data-warehouse
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
add a comment |
0
I have to know the about the three areas (source, staging and presentation), the type of data they contain and their purpose but cant seem to find much information about the data that they contain.
I am hoping that someone of the stack overflow community will be able to help me
database etl data-warehouse
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
you won't find a lot of details on the actual data, because it depends on your scenario. In a generic business case, your source data would for instance be your ERP system, maybe a separate warehouse system as well. Staging is always a preparation area where data from your sources is sometimes combined, denormalized, mapped, cleared up and at some point prepared for import into the Business Intelligence system that works with your fact and dimension data. And that BI system is your presentation system. But what data they contain really depends exclusively on your scenario.
– Dirk Trilsbeek
Jan 3 at 11:35
add a comment |
0
0
0
I have to know the about the three areas (source, staging and presentation), the type of data they contain and their purpose but cant seem to find much information about the data that they contain.
I am hoping that someone of the stack overflow community will be able to help me
database etl data-warehouse
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
I have to know the about the three areas (source, staging and presentation), the type of data they contain and their purpose but cant seem to find much information about the data that they contain.
I am hoping that someone of the stack overflow community will be able to help me
database etl data-warehouse
database etl data-warehouse
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
asked Jan 3 at 11:07
Carl O'BeirneCarl O'Beirne
216
216
you won't find a lot of details on the actual data, because it depends on your scenario. In a generic business case, your source data would for instance be your ERP system, maybe a separate warehouse system as well. Staging is always a preparation area where data from your sources is sometimes combined, denormalized, mapped, cleared up and at some point prepared for import into the Business Intelligence system that works with your fact and dimension data. And that BI system is your presentation system. But what data they contain really depends exclusively on your scenario.
– Dirk Trilsbeek
Jan 3 at 11:35
add a comment |
you won't find a lot of details on the actual data, because it depends on your scenario. In a generic business case, your source data would for instance be your ERP system, maybe a separate warehouse system as well. Staging is always a preparation area where data from your sources is sometimes combined, denormalized, mapped, cleared up and at some point prepared for import into the Business Intelligence system that works with your fact and dimension data. And that BI system is your presentation system. But what data they contain really depends exclusively on your scenario.
– Dirk Trilsbeek
Jan 3 at 11:35
you won't find a lot of details on the actual data, because it depends on your scenario. In a generic business case, your source data would for instance be your ERP system, maybe a separate warehouse system as well. Staging is always a preparation area where data from your sources is sometimes combined, denormalized, mapped, cleared up and at some point prepared for import into the Business Intelligence system that works with your fact and dimension data. And that BI system is your presentation system. But what data they contain really depends exclusively on your scenario.
– Dirk Trilsbeek
Jan 3 at 11:35
you won't find a lot of details on the actual data, because it depends on your scenario. In a generic business case, your source data would for instance be your ERP system, maybe a separate warehouse system as well. Staging is always a preparation area where data from your sources is sometimes combined, denormalized, mapped, cleared up and at some point prepared for import into the Business Intelligence system that works with your fact and dimension data. And that BI system is your presentation system. But what data they contain really depends exclusively on your scenario.
– Dirk Trilsbeek
Jan 3 at 11:35
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f54021096%2fexplain-the-purpose-of-three-areas-of-etl-source-staging-and-presentation-and%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
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%2f54021096%2fexplain-the-purpose-of-three-areas-of-etl-source-staging-and-presentation-and%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
you won't find a lot of details on the actual data, because it depends on your scenario. In a generic business case, your source data would for instance be your ERP system, maybe a separate warehouse system as well. Staging is always a preparation area where data from your sources is sometimes combined, denormalized, mapped, cleared up and at some point prepared for import into the Business Intelligence system that works with your fact and dimension data. And that BI system is your presentation system. But what data they contain really depends exclusively on your scenario.
– Dirk Trilsbeek
Jan 3 at 11:35