| |
|
|
| |
PRE REQUEST: RDBMS CONCEPTS AND WORKING KNOWLEDGE WITH ANY DATABASE |
|
| |
.................................................................................................................................................................................................................................... |
| |
AGENDA |
| |
..................................................................................................................................................................................................................................... |
| |
Introduction data warehouse concepts and data warehouse techniques, about star schema , snowflack schemas, life cycle of data warehouse etc |
| |
..................................................................................................................................................................................................................................... |
| |
POWERCENTER 7 ARCHITECTURE |
| |
INSTALLATION AND CONFIGURATION |
| |
...................................................................................................................................................................................................................................... |
| |
Overview |
| |
Installation - Windows |
| |
Repository Server Setup - Windows |
| |
PowerCenter Server Configuration (Windows) |
| |
...................................................................................................................................................................................................................................... |
| |
REPOSITORY ARCHITECTURE |
| |
...................................................................................................................................................................................................................................... |
| |
Repository Server Features |
| |
Repository Agents |
| |
Repository Types |
| |
....................................................................................................................................................................................................................................... |
| |
REPOSITORY SERVER ADMINISTRATION CONSOLE |
| |
........................................................................................................................................................................................................................................ |
| |
Repository Tasks |
| |
Backup and Restore |
| |
Activity Log |
| |
.......................................................................................................................................................................................................................................... |
| |
REPOSITORY MANAGER |
| |
......................................................................................................................................................................................................................................... |
| |
User Interface |
| |
Menus |
| |
Security |
| |
........................................................................................................................................................................................................................................... |
| |
EXPORTING/IMPORTING OBJECTS |
| |
TROUBLESHOOTING |
| |
......................................................................................................................................................................................................................................... |
| |
Error Messages |
| |
Error Logs |
| |
......................................................................................................................................................................................................................................... |
| |
ATA INTEGRATION CONCEPTS |
| |
......................................................................................................................................................................................................................................... |
| |
Data Integration |
| |
Mapping and Transformations |
| |
Tasks and Workflows |
|
| |
Metadata |
|
| |
............................................................................................................................................................................................................................................ |
|
| |
POWERCENTER COMPONENTS AND USER INTERFACE |
|
| |
.......................................................................................................................................................................................................................................... |
|
| |
PowerCenter Architecture |
|
| |
PowerCenter Client Tool |
|
| |
Lab - Using the Designer and Workflow Manager |
|
| |
.......................................................................................................................................................................................................................................... |
|
| |
SOURCE QUALIFIER |
|
| |
......................................................................................................................................................................................................................................... |
|
| |
Source Qualifier Transformation |
|
| |
Source Qualifier Joins |
|
| |
Source Pipelines |
|
| |
Lab - Load the Customer Staging Table |
|
| |
.......................................................................................................................................................................................................................................... |
|
| |
JOINS, FEATURES AND TECHNIQUES I
|
|
| |
.......................................................................................................................................................................................................................................... |
|
| |
Joiner Transformation |
|
| |
........................................................................................................................................................................................................................................ |
|
| |
LOOKUPS AND REUSABLE TRANSFORMATIONS |
|
| |
........................................................................................................................................................................................................................................ |
|
| |
Lookup Transformation |
|
| |
Reusable Transformations |
|
| |
....................................................................................................................................................................................................................................... |
|
| |
DEBUGGER |
|
| |
...................................................................................................................................................................................................................................... |
|
| |
Debugging Mappings |
|
| |
...................................................................................................................................................................................................................................... |
|
| |
SEQUENCE GENERATOR |
|
| |
...................................................................................................................................................................................................................................... |
|
| |
Sequence Generator Transformation |
|
| |
.................................................................................................................................................................................................................................... |
|
| |
LOOKUP CACHING, MORE FEATURES AND TECHNIQUES |
|
| |
.................................................................................................................................................................................................................................... |
|
| |
Lookup Caching |
|
| |
..................................................................................................................................................................................................................................... |
|
| |
SORTER, AGGREGATOR AND SELF-JOIN |
|
| |
..................................................................................................................................................................................................................................... |
|
| |
Sorter Transformation |
|
| |
Aggregator Transformation |
|
| |
Active and Passive Transformations |
|
| |
Data Concatenation |
|
| |
Self-Join |
|
| |
..................................................................................................................................................................................................................................... |
|
| |
ROUTER, UPDATE STRATEGY AND OVERRIDES |
|
| |
..................................................................................................................................................................................................................................... |
|
| |
Router Transformation |
|
| |
Update Strategy Transformation |
|
| |
Expression Default Values |
|
| |
Source Qualifier Override |
|
| |
Target Override |
|
| |
Session Task Mapping Overrides |
|
| |
........................................................................................................................................................................................................................................ |
|
| |
DYNAMIC LOOKUP AND ERROR LOGGING |
|
| |
.......................................................................................................................................................................................................................................... |
|
| |
Dynamic Lookup |
|
| |
Error Logging |
|
| |
Lab - Load Customer Dimension Table |
|
| |
......................................................................................................................................................................................................................................... |
|
| |
UNCONNECTED LOOKUP, PARAMETERS AND VARIABLES |
|
| |
........................................................................................................................................................................................................................................ |
|
| |
Unconnected Lookup Transformation |
|
| |
System Variables |
|
| |
Mapping Parameters and Variables |
|
| |
|
|
| |
MAPPLETS |
|
| |
........................................................................................................................................................................................................................................ |
|
| |
Mapplets |
|
| |
...................................................................................................................................................................................................................................... |
|
| |
MAPPING DESIGN |
|
| |
................................................................................................................................................................................................................................... |
|
| |
Designing Mappings |
|
| |
Workshop |
|
| |
.................................................................................................................................................................................................................................... |
|
| |
WORKFLOW VARIABLES AND TASKS |
|
| |
.................................................................................................................................................................................................................................... |
|
| |
Link Conditions |
|
| |
Workflow Variables |
|
| |
Assignment Task |
|
| |
Decision Task |
|
| |
Email Task |
|
| |
................................................................................................................................................................................................................................... |
|
| |
MORE TASKS AND REUSABILITY |
|
| |
................................................................................................................................................................................................................................. |
|
| |
Event Raise Task |
|
| |
Event Wait Task |
|
| |
Command Task |
|
| |
Reusable Tasks |
|
| |
Reusable Session Task |
|
| |
Reusable Session Configuration |
|
| |
PMCMD Utility |
|
| |
..................................................................................................................................................................................................................................... |
|
| |
WORKLETS AND MORE TASKS |
|
| |
.................................................................................................................................................................................................................................... |
|
| |
Worklets |
|
| |
Timer Task |
|
| |
Control Task |
|
| |
................................................................................................................................................................................................................................... |
|
| |
WORKFLOW DESIGN |
|
| |
................................................................................................................................................................................................................................. |
|
| |
Designing Workflows |
|
| |
Workshop (Optional) |
|
| |
................................................................................................................................................................................................................................ |
|
| |
PERFORMANCE TUNING |
|
| |
................................................................................................................................................................................................................................. |
|
| |
Performance Tuning Overview |
|
| |
Server Architecture |
|
| |
Measuring Performance Internal to Informatica |
|
| |
Establishing Baselines Internal to Informatica |
|
| |
Identifying Bottlenecks |
|
| |
Mapping Optimization |
|
| |
Session Optimization |
|
| |
................................................................................................................................................................................................................................ |
|
| |
MAPPING TECHNIQUES |
|
| |
............................................................................................................................................................................................................................... |
| |
Mapping Specification Documents |
| |
Stored Procedure |
| |
Mapping Parameters and Variables |
| |
Self Join |
| |
Transaction Control Transformation |
| |
Data Driven Aggregation |
| |
Incremental Aggregation |
| |
Unconnected Lookup Techniques |
| |
Dynamic Lookup Techniques |
| |
............................................................................................................................................................................................................................... |
| |
WORKFLOW TECHNIQUES |
| |
............................................................................................................................................................................................................................... |
| |
Workflow Alerts |
| |
Advanced Command Task and Parameter File Creation |
| |
.............................................................................................................................................................................................................................. |
| |
DATA ERROR HANDLING |
| |
............................................................................................................................................................................................................................... |
| |
Introduction |
| |
Data Error Handling with Transaction Control |
| |
.............................................................................................................................................................................................................................. |
