Call us : +91-452-4361885 ( ISO 9001:2015 certified company )

Informatica

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
  • 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
  • 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
  • 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
  • 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
Expression Transformation
  • Informatica Functions
    • Character Functions
    • Data cleansing and Coversion function
    • Date functions
    • Numeric and Scientific Funcations
    • Special functions
  • Lab Exercise
    • Mapping using Functions
  • 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
  • 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
  • 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
  • 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
  • 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
  • SCD Type 2 With Datetimestamp
  • SCD Type 3 Mapping
  • LAB Exercise
    • Mapping with SCD type 2and Type 3
  • Normalizer Transformation
  • Transaction Control Transformation
  • Lab Exercise
    • Mapping for to conver Multiple Columns to Multiple Rows
  • Reusable Transformations
  • Mapplet Transformation
    • Creating Mapplet
    • Advantages
    • Restriction in Usage of Transformations
  • Lab Exercise
  • Using parameter Files
  • Parameters and Variables
  • Workflow and Session Variables
  • Flat File Creation
  • Lab Exercise
  • 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
  • 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
  • Transforming one record into Multiple
  • Merging Multiple records into One
  • Removing Duplicate rows
  • Constraint Based Loading
  • Target Load Order
  • Performance Tuning methods
    • Finindg Bottelnecks in Source
  • Target and Mapping
    • Mapping & Session Optimization
    • Commit Points
  • Lab Exercises
Scroll to Top