Business Intelligence And Data Warehousing Directory

ETL Data warehousing tutorial
Preview:
Details: The ETL tutorial demonstrates real life data warehousing scenarios with solutions. The section depicts typical datawarehousing problems and shows many ways to handle them in various ETL tools, such as Datastage, Pentaho Data Integration (PDI), BODI, SAS, Oracle, Cognos DecisionStream and native SQL.

The DataWarehousing ETL tutorial describes and analyzes typical data warehouse problems.
It contains guided exercises and lessons on such Data Warehousing challenges as:
  • Processing of non-typical input files, like mainframes extracts, EDI and EPIC files.
  • Loading source system extracts - also how to copy the files via FTP, process multiple input files, etc.
  • It shows how to apply business rules in the ETL process
  • Surrogate key and natural key
  • Data warehouse architecture with data marts and reporting attached to it
  • Data quality and data cleansing process
    		•
    Address:
    Categories: DATA-WAREHOUSING ETL TUTORIALS
    BI DW Rating: 5