INFORMATICA ONLINE TRAINING @ LOWST FEE WITH INDEPTH COURSE CURRICULUM

[Raj2011]

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]