Our Courses  
 
INFORMATICA COURSE CONTENT

DATA WAREHOUSE CONCEPT

  • Introduction and Definition
  • Sources
  • Transformations
  • Targets
  • Data warehouse Architecture
  • Data Extraction
  • Data Transformations
  • Data Loading
  • Data Warehousing Approaches
  • Staging Area
  • Metadata
  • Repository
  • Data Mart
  • Data Modeling
  • Differences between OLTP and OLAP( DSS ) Systems
  • Operational Data Store( ODS )
  • Business Intelligence
  • Star Schema Design
  • Snow-Flake Scheme
  • Junk Dimension Confirmed Dimension
  • Fact less Fact Table
  • Types of Facts
  • Slowly Changing Dimensions( SCD )
  • INFORMATICA CONCEPTS

    • Introduction to INFORMATICA
    • ETL process in Informatica
    • ETL naming conventions of different vendors
    • Informatica Products (Power Center and Powermart)
    • Informatica Softwares (Server and Client)
    • Informatica Components and sub-components (Server and Client)
    • ETL Implementation Tasks in Informatica
    • Informatica Architecture

    INFORMATICA TRANSAFORMATIONS

    • Source Qualifier
    • Filter
    • Expression
    • Aggregator
    • Joiner
    • Router
    • Lookup
    • Stored Procedure
    • Union
    • Update Strategy
    • Sequence Generator
    • Rank
    • Sorter
    • Transaction Control Transformation
    • Xml Source Qualifier
    • Normalizer
    • Java

    INFORMATICA ADVANCE TOPICS

    • Implementing Constraint Based Loading
    • Debugging Mapping (Before creation of session and After creation Session)
    • Data Extraction from Flatfiles (Fixedwidth and Delimited)
    • Creating and Implementing Unconnected Lookup
    • Creating and Implementing Unconnected Stored Procedure
    • Creating and Implementing Reusable Transformation
    • Creating and Implementing Mapplet
    • Defining and Using Mapping Parameter
    • Defining and Using Mapping Variable
    • Data Extraction from Indirect Files (File Repository)
    • Implementing Target Load Plan
    • Slowly Changing Dimentions( SCD-TYPE1, SCD-TYPE2, SCD-TYPE3 )
    • SQL Override (SQ as Filter and SQ as a Joiner )
    • Reusable and Non-Reusable Sessions
    • Creating and Implementing Worklet
    • Active and Passive Transformations
    • Scheduling workflow
    • Executing workflow by using pmcmd command
    • Exporting and Importing Mappings
    • Creating and using User Defined Function (UDF)
    • Creating and Using E-mail task
    • Creating and Implementing DYNAMIC LOOKUP
    • Implementing CANGE DATA CAPTURES(CDC)
    • Implementing Pre SQL and Post SQL

    NOTE: After completion of course

    • Examples on Real-Time Scenarios
    • FAQs Review
    • Project Explanation
     
     
     
        Copyright © 2012-14 www.ifocusitolutions.com All rights reserved. Facebook Twitter LinkedIn Blog