DW ETL Process

Extract, transform and load (ETL) is a process in database usage and especially in data warehousing that involves: * Extracting data from outside sources * Transforming it to fit operational needs (which can include quality levels) * Loading it into the end target (database or data warehouse) Extract The first part of an ETL process involves extracting the data from the source systems. Most data warehousing projects consolidate data from different...

DataStage Architecture

The top half displays the Clients. Below there are two engines: The Server engine that runs DataStage server jobs and the parallel engine that runs parallel jobs. Our focus in this course is on Parallel jobs. The DataStage client components are: Administrator Administers DataStage projects and conducts housekeeping on the server Designer Creates DataStage jobs that are compiled into executable programs Director Used to run and monitor the DataStage...