softwarecabbges.com

We are providing Informatica online training by industry experts.

Based on Industry demand we are offering TERADATA 13 FREE FOR INFORMATICA.

• INFORMATICA POWER CENTER 9 + TERADATA 13 FREE:

• QA

        ORACLE SQL/PLSQL

        UNIX BASICS

        INFORMATICA POWER CENTER 9 + TERADATA 13 FREE:

Description:

The Course teaches the fundamentals of Informatica Power center 9 platforms, through online training and numerous hands-on lab exercises. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them successful Power center developers. Providing Training Material Support PPT s & Pdf Docs and Softwares.

Data Warehouse Concepts:

• Introduction to Data warehouse
• What is Data warehouse and why we need Data warehouse
• OLTP vs ODS vs 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
• DWH Approaches: Ralph Kimball’s vs Bill Inmon’s

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 PowerCenter 8 and 9 architecture
• Extraction, Transformation and loading process
• Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica Adminstration 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 Previllages

Source Object Definitions

•  
  • Source types

1.      Relational Tables (Oracle, Teradata)

2.      Flat Files (fixe width, Delimiter Files)

3.      Xml Files

4.      Cobol Files

5.      SalesForce

•  
  • 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
• Pre 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
• 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

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 lookups.
• 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 Lookups

• Usage and techniques
• Advantage
• Functionality

Lab 15 – Straight Load

Lab 16 – Conditional Lookups

Heterogeneous Targets

• Heterogeneous target types
• Target type conversions and limitations

Lab 17 – Heterogeneous Targets

Mapplets

• Functionality and Advantages
• Mapplet types and structure
• Mapplet limitations

Lab 18 – Mapplets

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 Workflows

• Concurrent Workflows
• Sequential Workflows
• Stopping, Starting and suspending tasks and workflows

Lab 21 – Sequential Workflow

Additional Transformations

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

Lab Sessions- For above transformations

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
• Parllel 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 Mappng 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

• WorkLets
• Worklets Limitation
• 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

Informatica Migrations:

• Copying Objects
• Objects export and import (XML)
• Deployment groups

Workflows Scheduling:

• Using Informatica
• Unix crontab, 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 prouction issues and support

·        Discuss various roles in ETL world

·        Busines Analyst, System Analyst

·        System Architect

·        Technical Architect, ETL Lead

·        Stakeholders, Busines users

·        Effective ways of using Data warehouse

·        Review various BI Reporting methods

Q/A-Inteview perparation/Placements

§  Answer students questions

§  Tips for interview preparation

§  How we can assist in placement and future growth

§  Discuss other realted technologies like Business Intelligence(BI)

§  Advacing career options