Scribd
Upload
167 views2 pages

ETL Process for Data Warehousing

The ETL process loads data from transactional databases into a data warehouse. It involves three main steps - extracting and loading data into staging tables, transforming the data in those tables, and then loading the transformed data into dimension and fact tables. The ETL process is initiated by the DAC client and uses the DAC and Informatica servers to execute mappings that move the data between the transactional database and the data warehouse based on metadata in the Informatica repository.

Uploaded by

Dilip Kumar Alugu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
167 views2 pages

ETL Process for Data Warehousing

The ETL process loads data from transactional databases into a data warehouse. It involves three main steps - extracting and loading data into staging tables, transforming the data in those tables, and then loading the transformed data into dimension and fact tables. The ETL process is initiated by the DAC client and uses the DAC and Informatica servers to execute mappings that move the data between the transactional database and the data warehouse based on metadata in the Informatica repository.

Uploaded by

Dilip Kumar Alugu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Understanding the ETL Process

ETL Process: Overview


• Data is loaded from the transactional database into the OBAW by the ETL process.
– Run using the DAC client
• Running an ETL initiates:
– Tasks run by the DAC server to prepare internal tables
– A series of Informatica mappings and transformations
executed by the Informatica server as requested by the DAC server
• The Informatica server accesses metadata in the Informatica repository to define how the data
moves between the transactional database and the OBAW.

ETL Process: Overview


At a high level, the ETL process is completed in three steps.
• The DAC server executes as many steps in parallel as
possible.

ETL Process Steps


• Step 1: Extract and load staging tables.
– Extracts and consolidates data from the transactional system
and writes to the OBAW staging tables
• Step 2: Transform data.
– Transforms data in staging tables in preparation for load
– Computes calculated fields
• Step 3: Load dimension and fact tables.
– Generates and maintains warehouse primary keys
– Loads hierarchy tables
– Loads dimension and fact tables

You might also like