Informatica

Description

Informatica is a company that offers data integration products for ETL, data masking, data Quality, data replica, data virtualization.

Course Content

1. Introduction to DWH
2. Introduction to Informatica
3. Informatica Architecture
4. Informatica Power Center
5. Informatica Components

• Designer
• Workflow manager
• Workflow monitor
• Repository Manager
• Admin console

1- Informatica Designer

• Introduction to designer
• Logon to designer

Defining Sources

• Database as a source
• Flat Files as a source
• XML Files as a source

Defining Targets

• Database as a target
• Flat Files as a target
• XML Files as a target

Mapping Introduction

• Designer Tools
• Source Analyzer
• Target Designer
• Transformation Developer
• Mapplet Designer
• Mapping Designer

2-Informatica Workflow Manager

Workflow manager Tools

• Task Developer
• Worklet Designer
• Workflow Designer

Session properties 

• Informatica Workflow Monitor
• Log Details and Debugging

Types of Transformations

• Active Transformations
• Passive Transformations
• Connected Transformations
• UnConnected Transformations

List of Transformations

• Source Qualifier Transformation
• Filter Transformation
• Sorter Transformation
• Expression Transformation
• Aggregator Transformation
• Router Transformation
• Union Transformation
• Rank Transformation
• Sequence Generator Transformation
• Joiner Transformation
• Stored procedure Transformation
• Normalize Transformation
• XML source qualifier Transformation
• Transaction Control Transformation
• SQL Transformation
• Look up Transformation
• Update strategy Transformation

Slowly Changing Dimension

Manual and Wizard 

• SCD1
• SCD2
  • Version
  • Date
  • Flag
• SCD3

Advanced Topics

1-  Transformation Developer

• Mapplet
• Mapplet advantage/ restrictions
• Worklet

2- Tasks

Reusable task

• Session
• Command
• Email

Non- Reusable task

• Timer
• Event wait
• Event raise
• Decision

3- Mapping Parameter

Variables

• Local Variables
• Mapping Variables
• Session Variables
• Workflow Variables
• Email Variables
• Built-In Variables (System information,$$$sessionstarttime)
• Connection Variables ($$RDBMSconn1)
• Set variable
• Setcountvariable
• Setmaxvariable
• Setminvariable
• File List/Indirect Method (to load multiple files)
• Scheduling informatica workflow
• PMCMD commands to run workflow
• Incremental aggregation
• Pushdown Optimization
• Target Load plan/ Stored procedure load plan
• Constraint based load ordering
• Test load plan
• Collect performance data
• Debugging Mapping
• Tracing levels
• Explaining Bad files (rejected records)
• Bulk Loading/Normal Loading
• External loaders
• Oracle SQL Loader (any one will be covered)
• Teradata Fast load
• Informatica BDE /Introduction to Informatica-ETL  Administration

Please Visit Informatica Official Site: