Informatica

DAY 1

Dimensional Modeling Refresher
Data Warehouse Architecture
Star and Snowflake Schema
Grain definition
Attributes, Dimensions and Facts
Slowly Changing Dimensions (Type1, 2, 3 and hybrid type)
Rapidly Changing Monster Dimensions
Role Playing Dimensions
Factless Fact Tables
Junk Dimensions
Sizing and Technology Selection/Architecture
Retail Case Study
Question Answer Session on Dimensional Modeling

Data Staging Overview
Importance of Good System Development Practices in Data Staging
High-Level Data Staging Plan
Data Staging tools
Detailed Plan

Dimensional Data Staging
Fact Table Loads and Warehouse operations
Data Quality and Cleansing
Aggregate Table and MOLAP Loads
Historical loads of Atomic-level Facts
Miscellaneous Issues

Introduction Informatica and Architectural Overview
Informatica resources
Informatica Professional Certification
Extraction, Transformation, and Loading process
PowerCenter 6 architecture
Additional Solutions
The Design Process

Repository Topics
Repository Server and Agent
Repository maintenance
Repository Server Administration Console
Security, repository privileges, and folder permissions
Object sharing, searching, and locking
Metadata extensions

Source Object Definitions
Source types
Source properties

Target Object Definitions
Target types
Target properties

Transformation Concepts
Transformation types and views
Transformation features and ports
Expression transformation
Informatica functions and data types

Mappings
Mapping components
Source Qualifier transformation
Pre SQL and Post SQL
Mapping validation
Data flow rules
Object export and import

DAY 2

Workflows
Workflow Tools
Workflow structure and configuration
Workflow Connections
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
Filtering views
Truncating Monitor Logs

Debugger
Debugger features
Debugger windows & indicators
Tips for using the Debugger

Filter transformation
Filter properties

Aggregator transformation
Aggregation functions and expressions
Aggregator properties
Using sorted data
Incremental Aggregation

Joiner transformation
Joiner types
Joiner conditions and properties
Joiner usage and Nested joins


DAY 3

Sorter transformation
Sorter properties
Sorter limitations

Lookup transformation
Lookup principles
Lookup properties
Lookup techniques

Target options
Row type indicators
Row loading operations
Constraint-based loading
Rejected row handling options

Update Strategy transformation
Update Strategy expressions
Smart aggregation
Refresh strategies

Router transformation
Using a Router
Router groups

DAY 4

Mapping Parameters and Variables
Mapping parameter and variable usage
System Variables
Variable functions

Conditional lookups
Usage and techniques
Advantage
Functionality

Heterogeneous Targets
Heterogeneous target types
Target type conversions and limitations

Mapplets
Functionality and advantages
Mapplet types and structure
Mapplet limitations

Reusable transformations
Advantages
Limitations
Promoting and copying transformations

Sequence Generator transformation
Using a Sequence Generator
Sequence Generator properties

Dynamic Lookup
Dynamic lookup theory
Usage and functionality
Advantages

Concurrent and sequential Workflows
Concurrent Workflows
Sequential Workflows
Stopping, starting, and suspending tasks and workflows

Additional Transformations
Rank transformation
Normalizer transformation
Stored Procedure transformation
External Procedure transformation
Advanced External Procedure transformation
Transaction Control transformation

Advanced Server Features
Partitioned Extraction and Loading
Session DTM Parameters
Folder Management
Repository Reporting
Installation and Configuration