Informatica Training

Informatica Training

Informatica contains a set of tools ( Informatica  Power Center, Data Quality, Data Transformation and many more ) with its ETL (Extraction, Transformation & Load ) toolset being the most widely used in the industry.

register for sap fi/co training

Additional Freebies – Along with the training we provide the following additional services.

  1. One Month of Informatica  support (After training, During the practice).
  2. Mock Interviews.
  3. Interview Tips.
  4. Resume Marketing

Intended Audience – Informatica  is intended for any of the following audience.

  1. Experienced Business Users who have been working extensively in Data Warehousing.
  2. Less than 1 yr of experience in Informatica or other DWH tools and wish to further renew his/her skills.
  3. Fresh Graduates

Table of Contents

Data Warehousing Basics

(Week 1 )

  • What is Data Warehousing
  • Why Use a Data Warehouse ?
  • Available Tools in the Market
  • Key Terms
  • Architectural Concepts
    • Primary Components
    • What is ETL ?
    • Data Cleansing
    • Data Merging
    • Data Aggregation
    • Data Scrubbing

Data Warehousing Concepts

( Week 2 )

  • Historic Data
    • Current Data & Historical
    • Complete History
    • Limited/Unlimited Number of Histories
  • Load Types
    • First Time Load ( Initial Extraction )
    • Delta Load
    • Full Load
    • Incremental Loads
  • Schema Types
    • Star Schema
    • Snowflake Schema
    • Integrated Star Schema
    • Advantages of Each Schema
  • Dimensional Modeling Techniques
    • Conceptual Modeling
    • Logical Modeling
    • Physical Modeling
    • Named Input
    • Formatted Input

Data Warehousing Concepts .. Continued

( Week 3 )

  • Data marts
    • Concept
    • Dependent vs Independent Data Mart
    • Enterprise Warehouse Schema
  • Implementation Methodology
    • Kimball Methodology
    • Inmon Methodology
  • Facts
    • Additive Facts
    • Semi Additive Facts
    • Non Additive Facts
    • Measures
    • HPQs
  • Dimension Table Types
    • Slowly changing Dimensions
    • Type 1/2/3 Dimensions
    • Zunc Dimensions
    • Confirmed Dimensions
    • Need of Time Dimension Comparison

Data Warehousing Concepts.. Continued

(Week 4 )

  • Why is BI (Business Intelligence ) Required ?
    • OLTP
    • DSS
    • OLAP
    • Types of OLAP
      • ROLAP
      • MOLAP
      • HOLAP
      • DOLAP
    • DDE Triplet
  • Reporting Architecture
  • Database Layer
  • Interface Layer
  • Server Layer
  • Presentation layer
  • BI Server Systems
  • BI Client Systems and Functionalities
  • Hieracheis
  • Need of Hierarchies in Reporting
  • Need for ODS in Data Warehousing

Informatica

( Week 5 )

  • Informatica Concepts
    • Basic Concepts
    • Key Terms
    • Product Architecture
    • Various Tools and thier roles
    • Power Center vs Power Mart
    • Informatica Server Configuration
  • Informatica Designer
    • Basic Concepts
    • Using the Designer
    • Working With Sources
    • Working with Flat Files, Targets
    • Mappings, Transformations, Mapplets
    • Working with Debugger
    • Implementing Type I , Type 2 , Type 3 mappings
    • Loading the Data into different Fact Tables
  • Transformations
    • Aggregator Transformations
    • XML Transformations
    • Expression
    • Filter
    • Joiner
    • Loook up Transformations
    • Rank, Router
    • Sequence Generator
    • Sorter Transformation
    • Source Qualifier Transformation
    • Stored Procedure Transformation
    • Transaction Control Transformation
    • Union Transformation
    • Update Stretegy Transformation
    • Connected vs Unconnected Transformations

Informatica

( Week 6 )

     

  • Workflow
    • Understanding the Server Architecture
    • Working with Workflows
    • Working with task assignment, command, decision, control, eventraise, event wait, timer, email, session task
    • working with work ltes
    • working with sessions
    • understanding commit points
    • recovering data
    • monitoring workflows
    • using multiple servers
    • log files
    • row error logging
    • session parameters
    • using incremental aggregation
  • Other Implementation Considerations
    • Understanding the Server Architecture
    • Working with Workflows
    • Working with task assignment, command, decision, control, eventraise, event wait, timer, email, session task
    • working with work ltes
    • working with sessions
    • understanding commit points
    • recovering data
    • monitoring workflows
    • using multiple servers
    • log files

register for sap fi/co training

0 thoughts on “Informatica Training

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s