Informatica Online Training

[A Trainer]

Dear Students

I am providing Informatica Online Training @ lowest fee. Contact at [email protected] for further details.

Here is the course curriculu m :

INFORMATI CA POWER CENTER 9 Course Content:

The Course teaches the fundament als of Informati ca Power center 9 platforms, through online training and numerous hands-on lab exercises . Students will gain a clear understan ding of the product and acquire the solid foundatio n needed to make them successfu l Power center developer s. Providing Training Material Support PPT s & Pdf Docs and Softwares .

Data Warehouse Concepts:

Introduct ion to Data warehouse
What is Data warehouse and why we need Data warehouse
OLTP vs ODS vs Data warehouse
Dimension al modeling
Star schema/Snowflake schema/Galaxy schema
Dimension s / Facts tables.
Slowly Changing Dimension s and its types.
Data Staging Area
Different types of Dimension s and Facts.
Data Mart vs Data warehouse
DWH Approache s: Ralph Kimball’s vs Bill Inmon’s

Informati ca Power Center 9:
Software Installat ion:
Informati ca 9 Server/Client Installat ion on Windows/Unix.
Power Center Architect ure and Component s:

Introduct ion to informati ca Power Center
Differenc e Between Power Center and Power Mart
PowerCent er 9 architect ure
PowerCent er 7 architect ure vs PowerCent er 8 and 9 architect ure
Extractio n, Transform ation and loading process
Power Center tools: Designer, Workflow manager, Workflow Monitor, Repositor y Manager, Informati ca Adminstra tion Console.
Repositor y Server and agent
Repositor y maintenan ce
Repositor y Server Administr ation Console
Security, Repositor y, privilege s and folder permissio ns
Metadata extension s

Power Center Developer Topics:
Lab 1- Create a Folder.
How to provide Previllag es
Source Object Definitio ns

Source types

Relationa l Tables (Oracle, Teradata)
Flat Files (fixe width, Delimiter Files)
Xml Files

Source propertie s

Lab 2- Analyze Source Data, Import Source.
Target Object Definitio ns

Target types
Target propertie s

Lab 3- Import Targets
Transform ation Concepts

Transform ation types and views
Transform ation features and ports
Informati ca functions and data types

Mappings

Mapping component s
Source Qualifier transform ation
Pre SQL and Post SQL
Mapping validatio n
Data flow rules

Lab 4 –Create a Mapping, session, and workflow
Workflows

Workflow Tools
Workflow Structure and configura tion
Workflow Tasks
Workflow Design and propertie s

Session Tasks

Session Task propertie s
Session component s
Transform ation overrides
Session partition s

Workflow Monitorin g

Workflow Monitor views
Monitorin g a Server
Actions initiated from the workflow Monitor
Gantt 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
Expressio n transform ation

Expressio n, variable ports, storing previous record values.

Different type of Ports
Input/ output / Variable ports and Port Evaluatio n
Filter transform ation

Filter propertie s

Lab 8- Expressio n and Filter
Aggregato r transform ation

Aggregati on function and expressio ns
Aggregato r propertie s
Using sorted data
Increment al Aggregati on

Joiner transform ation

Joiner types
Joiner condition s and propertie s
Joiner usage and Nested joins

Lab 9 – Aggregato r, Heterogen eous join
Working with Flat files
Importing and editing flat file sources & Targets
Lab Session – Use Flat file as source.
Sorter transform ation

Sorter propertie s
Sorter limitatio ns

Lab 10 – Sorter

Propagate Attribute s.
Shared Folder and Working with shortcuts .
Informati ca built in functions .

Lookup transform ation

Lookup principle s
Lookup propertie s
Lookup technique s
Connected and unconnect ed lookups.
Lookup Caches

Lab 11 – Basic and Advance Lookup
Target options

Row type indicator s
Row loading operation s
Constrain t- based loading
Rejected row handling options

Lab 12 – Deleting Rows
Update Strategy transform ation
Update strategy expressio ns
Lab 13 – Data Driven Inserts and Rejects
Router transform ation

Using a router
Router groups

Lab 14 – Router
Condition al Lookups

Usage and technique s
Advantage
Functiona lity

Lab 15 – Straight Load
Lab 16 – Condition al Lookups
Heterogen eous Targets

Heterogen eous target types
Target type conversio ns and limitatio ns

Lab 17 – Heterogen eous Targets
Mapplets

Functiona lity and Advantage s
Mapplet types and structure
Mapplet limitatio ns

Lab 18 – Mapplets
Reusable transform ations

Advantage s
Limitatio ns
Promoting and copying transform ations

Lab 19 – Reusable transform ations
Sequence Generator transform ation

Using a sequence Generator
Sequence Generator propertie s

Dynamic Lookup

Dynamic lookup theory
Usage and functiona lity
Advantage s

Lab 20 – Dynamic Lookup
Concurren t and sequentia l Workflows

Concurren t Workflows
Sequentia l Workflows
Stopping, Starting and suspendin g tasks and workflows

Lab 21 – Sequentia l Workflow
Additiona l Transform ations

Union Transform ation
Rank transform ation
Normalize r transform ation
Custom Transform ation
Transform ation Control transform ation
XML Transform ation
SQL Trasnform ation
Stored Procedure Transform ation
External procedure Transform ation
SQL Transform ation

Lab Sessions- For above transform ations
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
Sequentia l Batch Processin g
Parllel Batch Processin g

Lab Sessions – With Workflow tasks
Link Condition s
Team Based Developme nt

Version Control
Checking out and checking in objects.

Performan ce Tuning

Overview of System Environme nt
Identifyi ng Bottlenec ks.
Optimizin g Source, Target, mapping, Transform ation, session.

Mapping Parameter s and Variables

Introduct ion to Mappng Variables and Parameter s
Creating Mapping Variables and Updating Variables
Creating Parameter File and associati ng file to a Session
System Variables
Variables functions

Lab 26 - Override Mapping Variable with Parameter Files
Lab 27 – Dynamical ly Updating a Source Qualifier with Mapping Variable
Slowly Changing Dimension s Type 1, Type 2, Type 3
Increment al Loading
Lab 28– SCD 1, 2, 3
Reusable Workflow Tasks

WorkLets
Worklets Limitatio n
Sessions
Reusable Sessions

Lab 29 – Create Worklets using Tasks
Command Line Interface ( PMCMD)

Overview of PMCMD and functions .
Overview of PMREP and functions .

Lab 30 : PMCMD
PMREP
Informati ca Migration s:

Copying Objects
Objects export and import (XML)
Deploymen t groups

Workflows Schedulin g:

Using Informati ca
Unix crontab, third party tools.

Lab 30: Informati ca Project- Case Study

Sales Data mart.
Loading Dimension s and Facts.

ETL Best Practices and methodolo gies

Review the Industry best practices in ETL Developme nt
Review Real time project experienc es of trainer
Discuss what is learned technique s are useful in real world
How to design effective ETL process
Important considera tions in designing ETL process
Discuss real world prouction issues and support
Discuss various roles in ETL world
Busines Analyst, System Analyst
System Architect
Technical Architect, ETL Lead
Stakehold ers, Busines users
Effective ways of using Data warehouse
Review various BI Reporting methods

Q/A-Inteview perparati on/Placements

Answer students questions
Tips for interview preparati on
How we can assist in placement and future growth
Discuss other realted technolog ies like Business Intellige nce(BI)
Advacing career options

Thanks
Rajendra
Ph : +91-9660567626(M)
Email : [email protected]