Step 1 - Identification
Description of how the identification process is started.
Last updated
Description of how the identification process is started.
Last updated
In this initial step, understanding the business process and the form of the data is crucial. Here’s a detailed breakdown of what this entails:
Understand the Schema: Familiarize yourself with the source system’s database schema. This involves identifying tables, relationships, and the overall structure of the database.
Business Process Comprehension: Gain a clear understanding of the business processes from which you are extracting data. Knowing how data is used and flows through these processes is essential.
Identify Data Grains: Determine the granularity of the data within the system. This means identifying the most atomic level at which data is stored.
Key Metrics Identification: Recognize the essential metrics that are pivotal to the business processes. These metrics are critical for ensuring that the data you extract is meaningful and useful.
Dimensional Data and Terminology Systems: Assess if there is dimensional data that could be linked to terminological systems. This ensures that data can be standardized and universally understood, facilitating better interoperability and integration.