Informatica & Data Warehousing

Course Content

Introduction to Data warehousing

  • Overview of a DWH
  • Need of a data warehouse.
  • Data warehouse layer architecture.
  • OLTP/Transactional system and OLAP
  • Meta Data, Granularity, Data Mart
  • Design approach Top down/Bottom up
  • Designing a warehouse using Star/Snowflake schemas.
  • Dimension
  • Fact
  • CDC approach

Introduction to Informatica/ETL tools

  • The role of ETL tools in data warehousing.
  • An introduction to Informatica
  • Informatica Architecture
  • Components/Process flow

Informatica Designer

  • Basic Concepts
  • Using the designer.
  • Working with the Sources-Source Analyzer
  • Working with Relational/Flat file targets- Warehouse Designer.
  • Defining Keys in Informatica.
  • Working with Transformations –Transformation Developer
  • Working with Mapplets- Mapplet designer.
  • Creating mappings –Mapping Designer.
  • Understanding Pipelines in mappings.
  • Setting Target Load order.
  • Configuring Constraint Based loading.
  • Introduction to Mapping Parameters/Variables.
  • Implementing Type1, Type2, and Type3 Mappings.

Working with Transformations

  • Active/Passive Transformations
  • Connected/Unconnected Transformation
  • Importance of Source Qualifier.
  • Filter, Router
  • Expression
  • Sorter, Aggregator
  • Rank
  • Joiner
  • Lookup
  • SQL
  • Stored Procedure
  • Sequence generator
  • Union
  • Update Strategy
  • Xml transformation

Creating Workflows

  • Understanding the server Architecture
  • Working with Workflows
  • Working with Tasks Assignment,Command,Decision,Control,Event raise,
  • Event Wait,Timer,Email,Session Task
  • Working with Work lets
  • Working with Sessions
  • Understanding Commit Points
  • Recovering Data
  • Monitoring Work flows
  • Using Multiple Servers
  • Log files
  • Row Error Logging
  • Session parameters
  • Parameter files
  • Using Incremental Aggregation

Basic oracle and unix only for interview point of view

Mini project

Interview question and scenario