| Informatica Online TrainingCourse Duration - 30hrs |
Data warehouse basics
- OLTP System
- Datawarehouse
- Different Defeinitions of datawarehouse
- Difference between OPERATIONAL DS AND DWH
- Types of ETL
- Data Extraction
- DataTransformation
- Data Merging
- Data Loading
- Types of Data loading
- Data Aggregation
- Datawarehouse Approaches
- Top down approach and Bottom up approach
- DW Life cycle
- DW-database design
- Star schema and Snow flake schema
- Dimensional modelling
- Facts and dimensions
- Granuality
- Types of Dimensions
- Types of fact table
- Types of Olap
Informatica Power Center 8.6
Power center Administration
- Informatica Power center architecture
- Power center components
- ETL Plan
- Power center Clients
- Desiginer
- Workflow manager
- Work Flow monitor
- Workflow manager
- Repository manager
- Power center repository
- Administrative tool
- Repository services
- Integration services
- Power center domain
- Application services
- Concept of nodes and grid
- Service manager
- Power center administration console
Repository Administration
- Creating Repository Users and Groups .
- Connecting to the Repository.
- Creating a Group
- Assigning Privileges to a Group.
- Creating a User
- Creating a Folder
- Folder Permissions
- Creating Folders
Using the designer
- Creating Source Tables.
- Creating Target Definitions.
- Creating Target Tables
- Creating a Pass-Through Mapping
- Creating source definitions
- Creating a Mapping
- Connecting Transformations
Transformation Creation
- Using Transformations
- Creating a Mapping with Aggregate Values
- Active and passive transformations
- Creating an Aggregator Transformation
- Creating an Expression Transformation
- Creating a Lookup Transformation
- Connecting the Target
- Creating the Session
- Creating the Workflow
- Creating a Mapping with SCD Type 1 and SCD Type 2
- Creating a Filter Transformation
- Creating a Sequence Generator Transformation
- Creating a Stored Procedure Transformation
- Completing the Mapping
- Creating the Target
- Creating a Mapping with
- Creating an Expression Transformation
- Creating Router Transformations
- Completing the Mapping
- How to monitor loads
- Use of Workflow monitor
Using the workflow manager
- Connecting Transformations
- Creating Sessions and Workflows
- Configuring Database Connections in the Workflow Manager
- Creating a Reusable Session
- Creating a Workflow
- Running and Monitoring Workflows
- Opening the Workflow Monitor
Workflow Tasks
- Session
- Assignment task
- Link task
- Event raise task
- Event wait task
- Timer task
- Post session and Pre-session commands
- Session recovery
- Commit points
- Creation of Parameter file
- Mapping and session parameter
Performance tuning in ETL
- Various optimization technique
- Pushdown optimization
- Incremental aggregation
Practicals |
