 |
|
|
|
|
|
|
Classifieds: Education / Training | | Informatica online trainings @TEK | | Posted By: Muralidhar Kamuni at: 17, Nov 2011 12:58:21 PM IST | 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
Source types
o
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.
• |
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
