Process in which data from disparate, homogeneous or heterogeneous systems is cleansed, aggregated, consolidated, de-normalized and loaded into a single database or data warehouse after applying business rules is :
-
Data Profiling
-
Data Modelling
-
Data Integration
-
Data Staging
C
Correct answer
Explanation
Data Integration is the process of extracting data from multiple sources, cleansing it, applying business rules, and loading it into a unified target like a data warehouse. Data Profiling is analysis, Data Modelling is design, and Data Staging is temporary storage.