DW - Data Warehousing & Modeling
This is the process of converting normalized tables again into a de-normalized form. Here, a table may contain redundant information. This is a common technique within data warehousing where star schemas are used to optimize performance. Denormalizing a database consumes more space and slows OLTP performance but improves query performance in a BI environment.
Poor data quality examples: missing fields, old or inaccurate information, data conflicts, inaccessible data in legacy systems.
Data mapping is a process of defining a link between two distinct data models. It is used in software engineering to describe ideal ways to represent and access any form of information. It is used in data warehousing by linking source data models to target data models and additional for describing any transformations between these two models.
In a reporting system, a role-based security layer will enable you to assign roles for each user by allowing or restricting them from performing certain tasks.