Informatica

[one_full]

INFORMATICA

Course ID: CLETLI02

Introduction to Data warehousing

  • DWH – Architechture & Design
  • DWH – ETL and ETL Tools
  • DWH – Informatica Role

Architecture & Tool suite

  • Informatica suite Components
    • Informatica Client
    • Informatica server
  • Informatica Architecture
    • SOA
    • Domain, Node and Services

[accordion_item in="false" id_parent="faq" title="PowerCenter Tool Stack"]

  • Repository Manager
    • Over view of RM
    • Repository overview
  • Informtica Designer
    • Overview of ID
    • Source Analyzer
    • Mapping Designer
    • Warehouse Designer
    • Maplet Designer
    • Transformation Developer
  • Worklfow Manager & Workflow Monitor
    • Overview

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Basic Components for Mapping"]

  • Informatica Design Process
    • Create Source definition(s)
    • Create Target definition(s)
    • Create a Mapping
    • Create a Session Task
    • Create a Workflow from Task components
    • Run the Workflow and verify the results
  • Methods of Analyzing Sources in Source Analyzer
    • Relational Table Import (Oracle & SQL Server)
    • Datasource Connection Creation (Oracle & SQL Server)
    • Import from File
    • Manual Creation
  • Methods of Creating Target Definitions in Warehouse Designer
    • Datasource Connection Creation
    • Import from Database (Oracle & SQL Server)
    • Import from Flatfile
    • Manual Creation
    • Automatic Creation
  • Lab Exercise
    • Imporing TABLE from Oracle & SQL Server
    • Importing Flatfile
    • Create Table Definitation Manually

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Building a sample ETL process"]

  • Mapping Creation in Mapping Desinger
    • Sample Mapping
    • Objects in the Mapping
  • Workflow Creation in Workflow Manager
    • Sample workflow and Session
    • Objects in the Workflow
  • Lab Exercise
    • Imporing TABLE from Oracle & SQL Server
    • Create Table Definitation Manunally & Automatic
    • Creating Simple Passthrough Mappingand workflow

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Transformation & related components"]

  • Transformations
    • Types of Transforamtions
    • Active and Passive T/F
    • Creating Transformation
    • Creating and Configuring port
    • Connected and Unconnected T/F
  • Imformatica Data Types
    • Data Types and Data type conversion
  • Source Qualifier T/F
    • SQL Override
  • Mapping Debuging in Debuger
  • Lab Exercise
    • Debug the Simple Pass through Mapping

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Transformations in Detail"]

Expression Transformation
  • Informatica Functions
    • Character Functions
    • Data cleansing and Coversion function
    • Date functions
    • Numeric and Scientific Funcations
    • Special functions
  • Lab Exercise
    • Mapping using Functions

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Transformations in Detail"]

  • Filter Transformation
  • Router Transformation
  • Joiner Transformation
  • Union Transformation
  • Lab Exercises
    • Mapping using Joiner to jon two Different sources
    • Mapping using Router to route the date based on groups
    • Mapping using filter to Filtered the Data

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Transformations in Detail"]

  • Aggregator Transformation
    • Standard Aggregations
    • Incremental Aggregations
  • Sorter Transformation
  • Lab Exercises
    • Mapping for Standard Aggregation
    • Mapping using using sorter to sort the data from flatfile
    • Mapping using incremental Aggregation

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Transformations in Detail"]

  • Sequence Generator Transformation
  • Stored Procedure Transformation
    • Pre & Post Session
  • Rank Transformation
  • Caching Mechanism
  • Lab Exercises
    • Mapping to generate sequence numbers
    • Mapping to call Function or procedure from Relation Database.
    • Mapping to rank the salaries from employe table

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Transformations in Detail"]

  • Look UP Transformation
    • Connected & Unconnected
    • Static and Dynamic Caches
  • Update Strategy Transformation
  • Lab Exercises
    • Using to get the releated value with connected and Unconnected.
    • Updating table

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="SCD Concepts"]

  • Slowly Changing Dimensions
  • SCD Type 1 Mapping
  • SCD Type 2 Mapping – With Flag and Version
  • LAB Exercise
    • Mapping with SCD type 1 and Type 2

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="SCD Concepts Contd"]

  • SCD Type 2 With Datetimestamp
  • SCD Type 3 Mapping
  • LAB Exercise
    • Mapping with SCD type 2and Type 3

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Transformations in Detail"]

  • Normalizer Transformation
  • Transaction Control Transformation
  • Lab Exercise
    • Mapping for to conver Multiple Columns to Multiple Rows

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Reusable Components"]

  • Reusable Transformations
  • Mapplet Transformation
    • Creating Mapplet
    • Advantages
    • Restriction in Usage of Transformations
  • Lab Exercise

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Parameters & Variables"]

  • Using parameter Files
  • Parameters and Variables
  • Workflow and Session Variables
  • Flat File Creation
  • Lab Exercise

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Workflow & Components"]

  • Workflow Manager
    • Understanding Jobs & Scheduling
    • Session Task
    • Event Wait and Raise
    • Email Task
    • Creating Worklet
    • Control Task
    • Decision Task
  • Workflow Monitor
    • Operations in Workflow Monitor

[/accordion_item]
[accordion_item in="false" id_parent="faq" title="Basic Administration"]

  • Repository Manager
    • Creating ,Managing of Users,Groups and Folders
    • Analyze Object Dependencies
    • Local / Global Repsitory
    • Object Locking Mechanism
    • Object Export and Import Mechanism.
  • Repository Administrator
    • Over view and Operations
  • Lab Exercise
  • [/accordion_item]
    [accordion_item in="false" id_parent="faq" title="ETL Scenarios"]

    • Transforming one record into Multiple
    • Merging Multiple records into One
    • Removing Duplicate rows
    • Constraint Based Loading
    • Target Load Order

      [/accordion_item]
      [accordion_item in="false" id_parent="faq" title="Performance Tuning"]

      • Performance Tuning methods
        • Finindg Bottelnecks in Source
      • Target and Mapping
        • Mapping & Session Optimization
        • Commit Points
      • Lab Exercises

    [/accordion_item]
    [/one_full]


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>