Informatica
DCE Distributed Computing Environment
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
Dimensional Modeling Refresher
Data Staging Overview
Dimensional Data Staging
Introduction Informatica and Architectural Overview Informatica resources
Repository Topics
Source Object Definitions
Target Object Definitions
Transformation Concepts
Mappings
Workflows
Session Tasks
Workflow Monitoring
Debugger
Filter transformation
Aggregator transformation
Joiner transformation
Sorter transformation
Lookup transformation
Target options
Update Strategy transformation
Router transformation
Mapping Parameters and Variables
Conditional lookups
Heterogeneous Targets
Mapplets
Reusable transformations
Sequence Generator transformation
Dynamic Lookup
Concurrent and sequential
Workflows Additional Transformations
Advanced Server Features
|
|
||||||||||||
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
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
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
