Informatica Description


Course Content

  • Data Warehousing and Cleansing Concepts
  • Informatica Installation and Configuration
  • Working with active and passive transformation
  • Working with expression transformation
  • Working with Sorter, Sequence Generator, Filter transformation
  • Working with Joiner Transformation
  • Working with Ranking and Union Transformation
  • Understanding the Ranking and Union transformation, the characteristics and deployment.
  • Hands-on Exercise – Perform Ranking and Union transformation
  • Syntax for Rank and Dense Rank
  • Router Transformation
  • Hands-on Exercise – Perform router transformation
  • Source Qualifier Transformation and Mappings
  • Slowly Changing Dimension in Informatica
  • Mapplet and loading to multiple designer
  • Different types of designer: Mapplet, Worklet, target load plan, loading to multiple targets, linking property
  • Performance Tuning in Informatica
  • Repository Manager
  • Understanding and adopting best practices for managing repository.
  • Workflow Informatica
  • Parameters & Variables
  • Error handling and recovery in Informatica
  • High Availability & Failover in Informatica
  • Working with different utilities in Informatica
  • Flat file processing (advance transformations)
  • Dynamic targeting
  • Working with Java transformations
  • Unconnected Stored Procedure usage
  • Advance Concepts in SCD
  • Incremental Data Loading and Aggregation
  • Constraint based loading
  • XML Transformation and active look up
  • Profiling in PowerCenter
  • Workflow Creation and Deletion
  • Database Connection
  • Relational Database Tables
  • LinkedIn Connection
  • Connection with Sources
  • Push down optimization & Partitioning
  • Cache management

Quick Enquiry


Copyright © 2018 Caribou Media. All Rights reserved.