Master Data Management - MDM

Master Data Management (MDM) comprises the processes, governance, policies, standards and tools that consistently define and manage the critical data of an organization to provide a single point of reference.

ETL Extract, Transform and Load is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. ETL pipeline refers to set of processes extracting data from one system, transforming it, and loading into some database or data-lake.

common legacy vendors for data warehouse systems are −

• Microsoft SQL Server
• Oracle Exadata
• IBM Netezza
• Teradata
• Sybase IQ
• SAP Business Warehouse (SAP BW)

Extract

Data-IN: 

Data-Out:

Connection:

xz
Metadata:

d

Transform 

Load

Ref: Public Info.