Informatica PowerCenter Content

Informatica PowerCenter Data Warehousing Concepts:

  • Introduction to Data Warehouse
  • What is Data Warehouse and why we need Data Warehouse
  • Dimensions / Fact Tables
  • Different Types of Dimensions and Facts
  • Slowly Changing Dimensions and its types
  • Star schema/Snowflake schema
  • Data Mart vs Data Warehouse

ETL & Informatica

  • ETL Overview
  • Informatica Overview
  • Different ETL Products. Why Informatica?

Informatica Power Center 10.4: PowerCenter Architecture and Components:

  • Introduction to Informatica PowerCenter
  • Overview on Informatica PowerCenter Architecture and Services
  • Extract, Transformation and Loading Process (ETL Process)
  • PowerCenter Tools explanation:
    1. Server Tool - Administration Console 
    2. Client Tools - Repository Manager, Designer, Workflow Manager & Workflow Monitor

  • Overview on Informatica Admin Console, Creating Roles, Groups and Users and their permissions
  • Repository Security, Privileges, Folder Creation (Shared and Non-Shared) and Folder Permissions
  • OBDC creation and Usage
  • List of Transformation & Re-Usable transformation, Mapplet, Mapping
  • Lookup & Cache types and their usage
  • Mapping variable, Mapping parameter and Workflow variables
  • Debugger and Performance tuning
  • Web Service Sources and Targets Overview
  • Import and Export of Informatica object
  • Working with Deployment Group
  • Reusable/Dynamic mapping, session, worklet and workflow and their usage
  • Unix Basic command and advantages with Informatica.
  • Practical classes on Unix Environment
  • Practical on Real-time Scenarios
  • Overview on Version Control concept
  • Overview and discussion on real time unix script and making advantages with Informatica PowerCenter.

PowerCenter Developer Topics:

PowerCenter Designer: 

Source Analyzer:

  • Source Object Definitions
  • Types of Source Objects
  • Source Properties
  • Create & Import source (Oracle, CSV and Flat Files – Fixed Width/Delimited)
  • Different ways to create Source objects
  • Web service source definition
  • XML Source

Target Designer:

  • Target Object Definitions
  • Types of Target Objects
  • Target Properties
  • Create & Import Source (Oracle, CSV and Flat Files – Fixed Width/Delimited)
  • Copying Source Object as Target Object
  • Different ways to create Target objects
  • Web service target definition
  • Reverse engine (creating tables from target warehouse to database)
  • XML Target

Transformation Concepts:

  • Transformations list and overview
  • Types of transformation and features (Active & Passive)
  • Difference between reusable and non-reusable transformation and usage
  • Difference between Transformation, Mapplets and Mappings
  • Source Qualifier Transformation and its usage/Advantage
  • Creating Mapipngs, re-usable Transformation, mapplet, and mapping
  • Mapping Validation and Mapping Debugger
  • Mapplets usage and features
  • Lookup Caches and Types of Lookups
  • Data Flow rules and target load order
  • Pre-SQL & Post-SQL for Source/Target instance and their usable
  • Web service Source & Target and its usage
  • XML File parsing and generating

List of Transformations:

  • Aggregator
  • Expression
  • Filter
  • Joiner
  • Lookup (static/dynamic)
  • Normalizer
  • Rank
  • Router
  • Sequence Generator
  • Sorter
  • Source Qualifier
  • Stored Procedure
  • Update Strategy
  • Union
  • Transaction Control
  • XML Generator
  • XML Parser
  • UDF (User Defined Function)
  • XML Source
  • XML Target
  • Web Service
  • Unstructured Data

Reusable Transformations

  • Advantages & Limitations
  • Promoting and copying transformation

Workflow Manager:

  • Workflow Tools
  • Workflow structure and Configuration
  • Workflow tasks and Workflow variables
  • Workflow Designer and Properties

Tasks Overview:

  • Session
  • Email
  • Assignment
  • Event-Raise
  • Command
  • Event-Wait
  • Control
  • Timer
  • Decision

Task Developer & Worklet Designer:

  • Session Task and Properties
  • Session Components and Usage
  • Transformation Overrides
  • Session Partitions
  • Re-usable session and advantages
  • Re-usable worklet and advantages

Workflow Monitor:

  • Workflow Monitor
  • Monitoring a Server
  • Action Initiated from the workflow monitor
  • Gantt chart view and Task view

Concurrent and Sequential Workflows

  • Concurrent workflows
  • Sequence workflows
  • Starting, stopping and suspending tasks and workflows

Practical: Working with Mapping (Real Time Scenarios)

  1. Mapping with Flat File (Fixed Width/Delimited/CSV, Excel sheets)
  2. Mapping with Database Tables (Oracle)
  3. Simple Mapping (Pass through)
  4. Complex Mapping with Lookup (Connect/Un-Connected)
  5. Complex Mapping with more no of transformation
  6. Complex Mapping with complex logics
  7. Mapping with Expression, Filter, Router
  8. Mapping with Static and Dynamic cache lookup
  9. Mapping with Update Strategy Transformation (Insert, Update, Delete & Reject)
  10. Mapping with Normalize Transformation
  11. Mapping with Aggregator Transformation
  12. Mapping with Union Transformation
  13. Mapping with XML (source/target) Transformation
  14. Mapping with SCD Type I
  15. Mapping with SCD Type II (Version, Flag and Effective Date)
  16. Mapping with SCD Type III
  17. Mapping with Web Service Source, Target and Custom Web Service transformation
  18. Mapping with Unstructured Transformation
  19. Dynamic/Re-usable Mapping, Session, Worklet & Workflow with using Mapping Variable/Parameters and Workflow variables.
  20. Re-usable mapping concept and process

Performance Tuning:

  • Overview of system environment
  • Identifying Bottlenecks
  • Optimizing Source, Target, Mapping, Transformation and Session

Mapping Parameters and Variables:

  • Introduction to Mapping Parameters and Variables
  • Creating Mapping Parameters and Mapping Variable
  • Creating Parameter file and associating file to a session
  • System variables
  • Variable functions

Advance Topics:

  • Push Down Optimization
  • Link Conditions
  • Incremental Aggregation
  • Partition Techniques
  • Shared Folder and Working with Shortcuts
  • User defined functions.

Team Based Development

  • Version Control
  • Checking out and checking in objects

Target Options

  • Constraint based loading and Target load plan

Slowly Changing Dimensions:

  • SCD Type 1
  • SCD Type 2
  • SCD Type 3

Workflow Scheduling

  • Using Informatica scheduling

Informatica Migrations

  • Copying objects
  • Objects import and export (XML)
  • Development groups
  • Validation & Label

Command line interface (PMCMD)

  • Overview of PMCMD and functions
Others

  • Import and Export of Informatica object 
  • Working with Deployment Group 
  • Unix Basic command and advantages with Informatica

Comments

Post a Comment