Zobrazeno 1 - 10
of 12
pro vyhledávání: '"Qamar Shahbaz Ul Haq"'
Autor:
Qamar Shahbaz Ul Haq
Data mapping is required at many stages of the data warehouse lifecycle; every stage has its own unique requirements and challenges. A data mapper’s biggest challenge is to understand how data will flow from the source system to the final graphical
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::1bf83d60e30416514e61767204ea7334
https://doi.org/10.1016/b978-0-12-805185-6.00002-2
https://doi.org/10.1016/b978-0-12-805185-6.00002-2
Autor:
Qamar Shahbaz Ul Haq
After the data mapper has analyzed everything and has made a decision about the mapping, he or she needs to document the mapping. This document is used as a blueprint by extract, transform, load developers for implementation
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::6fe022517d2f14b095eac9aa8a67039c
https://doi.org/10.1016/b978-0-12-805185-6.00009-5
https://doi.org/10.1016/b978-0-12-805185-6.00009-5
Autor:
Qamar Shahbaz Ul Haq
Data warehouse is becoming common and almost every organization with good amount of data wants to get benefit of their data. However data quality issues create major disappointment for business users when end reports provide in correct and in complet
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::eef4fdfa1360a7c57e43b44b275b4bc5
https://doi.org/10.1016/b978-0-12-805185-6.00011-3
https://doi.org/10.1016/b978-0-12-805185-6.00011-3
Autor:
Qamar Shahbaz Ul Haq
A data warehouse can use two types of identification systems for its data. Natural keys come from the source system, and surrogate keys are defined in the data warehouse.
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::8abd5e8b31421c836a0b9563417ea076
https://doi.org/10.1016/b978-0-12-805185-6.00008-3
https://doi.org/10.1016/b978-0-12-805185-6.00008-3
Autor:
Qamar Shahbaz Ul Haq
The logical data model defines how data will be stored or linked in the data warehouse. The process gives a single picture of an organization’s business and is the key process in the data warehouse lifecycle.
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::1940ea684d31111fb89707981947384c
https://doi.org/10.1016/b978-0-12-805185-6.00004-6
https://doi.org/10.1016/b978-0-12-805185-6.00004-6
Autor:
Qamar Shahbaz Ul Haq
There are two types of data mapping done in any data warehouse project. The high-level logical data mapping is part of the data modeling process, and implementation-oriented physical data mapping is used to document the transformation rule in detail.
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::3aa843a84eb3be05ef0e6b9398b3e7f4
https://doi.org/10.1016/b978-0-12-805185-6.00003-4
https://doi.org/10.1016/b978-0-12-805185-6.00003-4
Autor:
Qamar Shahbaz Ul Haq
Data mapping can be started after all required information is available to the data mapper; this chapter explains these prerequisites.
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::8910455c073cc69f86a01216e204e4b7
https://doi.org/10.1016/b978-0-12-805185-6.00007-1
https://doi.org/10.1016/b978-0-12-805185-6.00007-1
Autor:
Qamar Shahbaz Ul Haq
A data mapper uses the available tools or information in the mapping source data to target, but needs a thinking strategy should he or she use to accomplish this task.
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::60af7716dff6d41fe3061a608dd1ed06
https://doi.org/10.1016/b978-0-12-805185-6.00005-8
https://doi.org/10.1016/b978-0-12-805185-6.00005-8
Autor:
Qamar Shahbaz Ul Haq
After understanding source data, writing the transformation rule is a simple process in 90% of the time. However, there can be cases when special rules and handling are required. This chapter explains mapping scenarios that can be used to understand
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::8e3021544f4c59f0da549371186cb514
https://doi.org/10.1016/b978-0-12-805185-6.00012-5
https://doi.org/10.1016/b978-0-12-805185-6.00012-5
Autor:
Qamar Shahbaz Ul Haq
The uniqueness of an item gives it identity in its environment. Without uniqueness, we cannot identify objects or concepts in our business; hence, it is very important to find all information that is required for identification purposes.
Externí odkaz:
https://explore.openaire.eu/search/publication?articleId=doi_________::a00985162ecf1da62745c3bc70b50a22
https://doi.org/10.1016/b978-0-12-805185-6.00006-x
https://doi.org/10.1016/b978-0-12-805185-6.00006-x