Datawarehousing Informatica Online Training
- INFORMATICA OVERVIEW
- History of Informatica
- Opportunities of Informatica
- Other ETL tools
- Power centre Administration
- Informatica Power centre architecture
- Power centre components
- ETL Plan
- Power centre Clients
- Designer
- 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 shortcuts
- 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
- Normalizer Transformation
- SQL Transformation
- Filter Transformation
- Sequence Generator Transformation
- Source Qualifier Transformation
- Router Transformations
- Rank Transformations
- XML Parser Transformation
- XML Generator Transformation
- SQL Override in source qualifier Transformation and lookup Transformation
- Connecting the Target
- Connecting Transformations
- Creating a Mapping
- Completing the Mapping
- Creating a Mapping with Aggregate Values
- Target load order plan
- Mapping wizards
- Reusable Transformation
- WORKFLOW MANAGER
- Creating the Session
- Creating the Workflow
- Using the workflow manager
- 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
- Post session and Pre-session commands
- Commit points
- Mapping and session parameter
- Pushdown optimization
- 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
- Exercises for each Transformation
- Datawarehosuing Concepts
No comments:
Post a Comment
Note: only a member of this blog may post a comment.