|
Business Intelligence Training Overview
Working on a ETL Tool like Informatica project can be overwhelming if you don't have a solid grounding in the basics. It's difficult to focus on the goals of the project when you're bogged down by unanswered questions - or don't even know what questions to ask. By arming yourself with knowledge of the concepts and fundamentals, you can hit the ground running. This course provides an overview that gives business and information technology professionals the confidence to dive right into their business intelligence and data warehousing activities and contribute to their success.
What you will learn
- Basic concepts of ETL & Informatica
- Industry terminology
- Critical success factors & risks
- Transformations & Mapping Techniques
- Data warehousing & business intelligence development processes
- Culture, politics & organizations
- Best practices
- Industry trends
Business Intelligence Audience
This course provides an introduction to those who may be involved in the process of designing and implementing a ETL application or data warehouse. It is also for those who just need to understand what is involved in managing either a business intelligence or data warehouse project.
Business Intelligence Prerequisites
All the participants must be aware of any RDBMS activities along with its application.
Business Intelligence Training Course duration
Five(5) Days Classroom & Lab Session.
Business Intelligence Training Course outline
Day 1 & 2
Introduction Informatica and Architectural Overview
Repository Topics
- Repository Server 9.X and Agent
- Repository maintenance
- Security, repository privileges, and folder permissions
- Arch of Informatica 9.X
- Tools Information
- Domain & Node Config
Source Object Definitions
- Source types (RDBMS[Oracle],TEXT,XML)
- Source properties
Target Object Definitions
- Target types (RDBMS[Oracle],TEXT)
- Target properties
Transformation Concepts
- Transformation types and views
- Transformation features and ports
Mappings
- Mapping components
- Source Qualifier transformation
- Mapping validation
- Data flow rules
Session Tasks
- Session Task properties
- Session components
Workflows
- Workflow Tools
- Workflow structure and configuration
- Workflow Connections
- Workflow Tasks
- Workflow Design and properties
Workflow Monitoring
- Workflow Monitor views
- Monitoring a Server
- Actions initiated from the Workflow Monitor
Day 2 & 3
Filter transformationExpression transformation
- Expression properties
- IN, OUT, Variable Ports
Source Qualifier transformationRouter transformation(Multi Targets)
- Group properties
- Group Based Filters
Joiner transformation
- Joiner properties
- Homogeneous Sources
- Heterogeneous Sources
- Performance Issues
- Source Qualifier Based Joins
Rank transformation Sequence Generator transformationDay 4
Aggregator transformationWorking with Parameters & Variables
Target Load Plan
Lookup transformation
- Lookup principles
- Lookup properties
- Connected & Un-Connected
Update Strategy transformation
- Update Strategy expressions
- Smart aggregation
- Refresh strategies
Day 5
Working with Session Properties
- Creating using Task Developer
- Creating using Workflow Designer
Workflow Process Management(WPM)
Concurrent and sequential Workflows
- Concurrent Workflows
- Sequential Workflows
- Stopping, starting, and suspending tasks and workflows
Workflow Objects
- Link
- Decision
- Event Wait
- Event Raise
- Control
- Command
- Email
- Worklets
- Scheduling
Summary & Conclusion
- Repository Backup & Restoring
|
