Informatica Training in Bangalore - Classroom and Online in Marathalli Bangalore

Informatica Online Training Course

Data Warehouse Concepts:

• Introduction to Data warehouse

• What is Data warehouse and why we need Data warehouse

• Dimensional modeling

• Star schema/Snowflake schema/Galaxy schema

• Dimensions / Facts tables.

• Slowly Changing Dimensions and its types.

• Data Staging Area

• Different types of Dimensions and Facts.

• Data Mart vs Data warehouse

Informatica Power Center 9:

Software Installation:

Informatica 9 Server/Client Installation on Windows/Unix.

Power Center Architecture and Components:

• Introduction to Informatica Power Center

• Difference Between Power Center and Power Mart

• PowerCenter 9 architecture

• PowerCenter 7 architecture vs Power Center 8 and 9 architecture

• Extraction, Transformation and loading process 

Power Center tools: Designer, Workflow manager, Workflow Monitor,

Repository Manager, Informatica Administration Console.

• Repository Server and agent

• Repository maintenance

• Repository Server Administration Console

• Security, Repository, privileges and folder permissions

• Metadata extensions

Power Center Developer Topics:

Lab 1- Create a Folder.

• How to provide Privileges

• Source Object Definitions

        Source types

-       Relational Tables (Oracle, Teradata)
–       Flat Files (fix width, Delimiter Files)
–       Xml Files
–       COBOL Files
–       Sales Force

Source properties

Lab 2- Analyze Source Data, Import Source.

• Target Object Definitions

-       Target types
–       Target properties

Lab 3- Import Targets

• Transformation Concepts

• Transformation types and views

• Transformation features and ports

• Informatica functions and data types

Mappings

• Mapping components

• Source Qualifier transformation

• SQL and Post SQL

• Mapping validation

• Data flow rules

Lab 4 –Create a Mapping, session, and workflow

Workflows

• Workflow Tools

• Workflow Structure and configuration

• Workflow Tasks

• Workflow Design and properties

Session Tasks

• Session Task properties

• Session components

• Transformation overrides

• Session partitions

Workflow Monitoring

• Workflow Monitor views

• Monitoring a Server

• Actions initiated from the workflow Monitor

• chart View and Task view.

Lab 6 – Start and Monitor a Workflow

Debugger

• Debugger features

• Debugger windows

• Tips for using the Debugger

Lab 7 –The Debugger

Expression transformation

• Expression, variable ports, storing previous record values.

Different type of Ports

• Input/ output / Variable ports and Port Evaluation

• Filter transformation

• Filter properties

Lab 8- Expression and Filter

Aggregator transformation

• Aggregation function and expressions

• Aggregator properties

• Using sorted data

• Incremental Aggregation

Joiner transformation

• Joiner types

• Joiner conditions and properties

• Joiner usage and Nested joins

Lab 9 – Aggregator, Heterogeneous join

• Working with Flat files

• Importing and editing flat file sources & Targets

Lab Session – Use Flat file as source.

Sorter transformation

• Sorter properties

• Sorter limitations

Lab 10 – Sorter

• Propagate Attributes.

• Shared Folder and Working with shortcuts.

• Informatica built in functions.

Lookup transformation

• Lookup principles

• Lookup properties

• Lookup techniques

• Connected and unconnected lookup.

• Lookup Caches

Lab 11 – Basic and Advance Lookup

 Target options

• Row type indicators

• Row loading operations

• Constraint- based loading

• Rejected row handling options

Lab 12 – Deleting Rows

• Update Strategy transformation

• Update strategy expressions

Lab 13 – Data Driven Inserts and Rejects 

• Router transformation

Using a router

Router groups

Lab 14 – Router

• Conditional Lookup

Usage and techniques

Advantage

Functionality

Lab 15 – Straight Load
Lab 16 – Conditional Lookup

 Heterogeneous Targets

• Heterogeneous target types

• Target type conversions and limitations

Lab 17 – Heterogeneous Targets

M-applet

• Functionality and Advantages

• M-applet types and structure

• M-applet limitations

Lab 18 – M-applet

• Reusable transformations

• Advantages

• Limitations

• Promoting and copying transformations

Lab 19 – Reusable transformations

• Sequence Generator transformation

• Using a sequence Generator

Sequence Generator properties

• Dynamic Lookup

• Dynamic Lookup theory

• Usage and functionality

• Advantages

Lab 20 – Dynamic Lookup

• Concurrent and sequential WorkflowsStopping, Starting and suspending tasks and workflows

  • Concurrent Workflows
  • Sequential Workflows

Lab 21 – Sequential Workflow

• Additional TransformationsLab Sessions- For above transformations

  • Union Transformation
  • Rank transformation
  • Normalize transformation
  • Custom Transformation
  • Transformation Control transformation
  • XML Transformation
  • SQL Transformation
  • Stored Procedure Transformation
  • External procedure Transformation
  • SQL Transformation

• Error Handling

• Overview of Error Handling Topics

Lab 22 – Error handling fatal and non Fatal

• Workflow Tasks:

  • Command
  • Email
  • Decision
  • Timer
  • Control
  • Even Raise and Wait
  • Sequential Batch Processing

Parallel Batch Processing

• Lab Sessions – With Workflow tasks

• Link Conditions

• Team Based Development

Version Control

Checking out and checking in objects.

• Performance Tuning

• Overview of System Environment

• Identifying Bottlenecks.

Optimizing Source, Target, mapping, Transformation, session.

• Mapping Parameters and Variables

Introduction to Mapping Variables and Parameters

• Creating Mapping Variables and Updating Variables

• Creating Parameter File and associating file to a Session

• System Variables

• Variables functions

Lab 26 – Override Mapping Variable with Parameter Files
Lab 27 – Dynamically Updating a Source Qualifier with Mapping Variable

• Slowly Changing Dimensions Type 1, Type 2, Type 3

• Incremental Loading

Lab 28– SCD 1, 2, 3

• Reusable Workflow Tasks

• Work Lets

• Work lets Limitation

• Sessions

• Reusable Sessions

Lab 29 – Create Worklet using Tasks

• Command Line Interface

• Overview of PM REP and functions.

• PM REP

• Informatica Migrations:

Copying Objects

• Objects export and import (XML)

• Deployment groups

• Workflows Scheduling:

• Using Informatica

• Unix cron tab, third party tools.

Lab 30: Informatica Project- Case Study

• Sales Data mart.

• Loading Dimensions and Facts.

• ETL Best Practices and methodologies

• Review the Industry best practices in ETL Development

• Review Real time project experiences of trainer

• Discuss what is learned techniques are useful in real world

• How to design effective ETL process

• Important considerations in designing ETL process

• Discuss real world production issues and support

• Discuss various roles in ETL world

• Business Analyst, System Analyst

• System Architect

• Technical Architect, ETL Lead

• Stakeholders, Business users

• Effective ways of using Data warehouse

• Review various BI Reporting methods

  • Q/A-Interview preparation/Placements

  • Answer students questions

  • Tips for interview preparation

  • How we can assist in placement and future growth

  • Discuss other related technologies like Business Intelligence (BI)

  • Advancing career options