Informatica power center online training in Abilene, Texas For Sale

INFORMATICA POWER CENTER 8.X Course Content:
Description:
The Course teaches the fundamentals of Informatica Power center 8.x platform, 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.
Course Duration: 30 hours
Prerequisites: SQL Basics. Software: Informatica, Oracle, Toad
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 8.x:
Software Installation:
Informatica 8.x Server/Client Installation on Windows/Unix.
Power Center Architecture and Components:
? Introduction to informatica Power Center
? PowerCenter 8.x architecture
? PowerCenter 7 architecture vs PowerCenter 8 architecture
? Extraction, Transformation and loading process
? Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager.
? 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.
Source Object Definitions
o Source types
o 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.
Lab 11 ? Basic 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
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
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
Lab 28? SCD 1, 2, 3
Reusable Workflow Tasks
? WorkLets
? Worklets Limitation
Lab 29 ? Create Worklets using Tasks
Command Line Interface ( PMCMD)
? Overview of PMCMD and functions.
Lab 30 : PMCMD
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.
Contact email id :smartittrainings@gmail.com
Contact number : 248 906 xxxx Or xxxxxxxx20 ( India)