INFORMATICA POWERCENTER 8.X/9.X
- Informatica Overview
- History of Informatica
- Opportunities of Informatica
- Other ETL tools
- Power center Administration
- Informatica Power center architecture
- Power center components
- ETL Plan
- Power center Clients
- Designer
- Workflow manager
- Work Flow monitor
- 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
- DESIGNER
- Types of Transformations
- Connected and Unconnected Transformations
- Active and Passive Transformations
- Creating Source Tables
- Creating Target Definitions
- Creating Target Tables
- Creating source definitions
- Creating a Mapping
- Connecting Transformations
- Transformation Creation
- Importing sources and targets (database objects)
- Importing sources and targets (flat files and XML files)
- Using Transformations
- Aggregator Transformation
- Expression Transformation
- Lookup Transformation (Connected and Un Connected)
- Union Transformation
- Joiner Transformation
- Filter Transformation
- Sequence Generator Transformation
- Stored Procedure Transformation
- Source Qualifier Transformation
- Router Transformations
- Rank Transformations
- Update Strategy Transformation
- XML Transformation
- SQL Override in source qualifier Transformation and lookup Transformation
- Connecting the Target
- Connecting Transformations
- Creating a Mapping
- Completing the Mapping
- Creating a Pass-Through Mapping
- Creating a Mapping with SCD Type 1 and SCD Type 2
- Creating a Mapping with Aggregate Values
- Target load order plan
- Mapping wizards
- Reusable Transformation
- Mapplet overview and usage
- WORKFLOW MANAGER
- Creating the Session
- Creating the Workflow
- Using the workflow manager
- Creating Sessions and Workflows
- Constraint base loading
- 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 techniques
- Pushdown optimization
- Incremental aggregation
- WORKFLOW MONITOR
- How to monitor loads
- Uses of Workflow monitor
- Monitoring the jobs
- How to get Session Logs and Workflow Logs
- Real time Questions and Answers
- Real time scenarios
- Exercises for each Transformation
- Datawarehosuing Concepts
