Informatica

INTRODUCTION TO DATAWAREHOUSING

·         Data Warehousing Concepts

·         Dataware housing (what/Why/How)

·         Data Modelling(Schemas, FACTS and DIMENSIONS)

·         Slowly Changing Dimensions

·         Metadata

POWERCENTER COMPONENTS AND USER INTERFACE

·         PowerCenter Architecture

·         PowerCenter Client Tools

·         Lab – Using the Designer and Workflow Manager

SOURCE QUALIFIER

·         Source Qualifier Transformation

·         Lab Project Overview

·         Lab A – Load Payment Staging Table

·         Source qualifier Joins

·         Lab B – Load Product Staging Table

·         Source Pipelines

·         Lab C – Load Dealership and Promotions Staging Table and Real time issues

EXPRESSION, FILTER, FILE LISTS AND WORKFLOW SCHEDULER

·         Expression Editor

·         Filter Transformation

·         File Lists

·         Workflow Scheduler

·         Lab – Load the Customer Staging Table and Real time issues

JOINS, FEATURES AND TECHNIQUES I

·         Joiner Transformation

·         Shortcuts

·         Lab A – Load Sales Transaction Staging Table

·         Lab B – Features and Techniques I and Real time issues

LOOKUPS AND REUSABLE TRANSFORMATIONS

·         Lookup Transformation

·         Reusable Transformations

·         Lab A – Load Employee Staging Table

·         Lab B – Load Date Staging Table and Real time issues

DEBUGGER

·         Debugging Mappings

·         Lab – Using the Debugger

SEQUENCE GENERATOR

·         Sequence Generator Transformation

·         Lab – Load Date Dimension Table and Real time issues

LOOKUP CACHING, MORE FEATURES AND TECHNIQUES

·         Lookup Caching

·         Lab A – Load Promotions Dimension Table

·         Lab B – Features and Techniques II

·         Review and more Lab Activities and Real time issues

ROUTER, UPDATE STRATEGY AND OVERRIDES

·         Router Transformation

·         Update Strategy Transformation

·         Expression Default Values

·         Source Qualifier Override

·         Target Override

·         Session Task Mapping Overrides

·         Lab – Load Employee Dimension Table and Real time issues

DYNAMIC LOOKUP AND ERROR LOGGING

·         Dynamic Lookup

·         Error Logging

·         Lab – Load Customer Dimension Table

UNCONNECTED LOOKUP, PARAMETERS AND VARIABLES

·         Unconnected Lookup Transformation

·         System Variables

·         Mapping Parameters and Variables

·         Lab – Load Sales Fact Table

SORTER, AGGREGATOR AND SELF-JOIN

·         Sorter Transformation

·         Aggregator Transformation

·         Active and Passive Transformations

·         Data Concatenation

·         Self-Join

·         Lab – Reload the Employee Staging Table and Real time issues

SCD type1 – LAB

SCD type2 – LAB

SCD type3 – LAB

MAPPLETS

·         Mapplets

·         Lab – Load Product Daily Aggregate Table

·         Review and more Lab Activities and Real time issue

WORKFLOW VARIABLES AND TASKS

·         Link Conditions

·         Workflow Variables

·         Assignment Task

·         Decision Task

·         Email Task

·         Lab – Load Product Weekly Aggregate Table

MORE TASKS AND REUSABILITY

·         Event Raise Task

·         Event Wait Task

·         Command Task

·         Reusable Tasks

·         Reusable Session Task

·         Reusable Session Configuration

WORKLETS AND MORE TASKS

·         Worklets

·         Timer Task

·         Control Task

·         Lab – Load Inventory Fact Table

INFORMATICA ANALYST 9.1

·         Analyst GUI

·         Metadata and Data access/import

·         Column Profiling

·         Frequency/Patterns/Statistics/Drill downs

·         Rule Profiling

·         Out Of The Box rules

·         Custom rules

·         Reference Tables Management

·         Project Collaboration

·         Data Quality Score carding

INFORMATICA DEVELOPER 9.1

·         Developer GUI

·         Developer Profiling including:

·         Mid-stream profiling

·         Join analysis profiling

·         Building Data Quality Mapplets and Rules

·         Data Standardization

·         Cleanse, transform and parse data using DQ transformations such as the Case Converter, Merge, Labeller, Standardizer, Parser

·         Address Validation

·         Perform address validation and create AV mapplets and mappings 

·         Matching

·         Group data prior to matching to improve matching performance

·         Perform DQ and Identity Matching to identify duplicate records

·         Develop Matching Mapplets

·         Associate and Consolidate matched data

·         Work with the Data Quality Assistant

·         PowerCenter Integration

·         Parameterization

·         Data Quality Workshop