Details
About The Course:
Hamsini Technologies's Informatica PowerCenter 9.X Developer & Admin Course, will introduce the participants to work with the PowerCenter. Developers can use Informatica to create, execute, as well as administer, monitor and schedule ETL
processes and understand how these are used in data mining operations. The course will also cover Installation & Configuration of Informatica PowerCenter 9.X and basic Administration Activities. Participants will also get to implement one project towards the
end of the course.
Course Objectives
After the completion of the Informatica course at Hamsini Technologies, you will be able to :
1. Understand and identify different Informatica Products
2. Describe Informatica PowerCenter architecture & its different components
3. Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
4. Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
5. Understand Workflow Task and job handling
6. Describe Mapping Parameter and Variables
7. Perform debugging, troubleshooting, error handling and recovery
8. Learn to calculate cache requirement and implement session cache
9. Execute performance tuning and Optimization
10. Recognize and explain the functionalities of the Repository Manager tool.
11. Identify how to handle services in the Administration Console
12. Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
13. Gain insight on ETL best practices using Informatica
Outline
Informatica Training Course Content:
1.Datawarehousing Concepts:
- Introduction
- Definitions
- SDLC of DWH project
- Datamarts(Dependent and Independent)
- Dimensional Modelling Different Types of Schemas.
- Definition of Dimension and Types
- Definition of Fact and Types
- SCD-1, SCD-2, SCD-3 Concepts.
2.Informatica
- Informatica Installation
- Informatica Architecture
- Oracle Installation
- ODBC and Relational Connections
- Transformations
- Sorter
- Rank
- Filter
- Router
- Expression
- Aggregator
- Joiner
- Lookup
- Union
- Source qualifier
- SQL
- Seq generator
- Update Strategy
- XML
- Mapplet I/P,Mapplet O/P
3.Implemantaions:
- Slowly Changing Dimension – 1 Practical
- Slowly Changing Dimension -2 Practical
- Dynamic Cache Practical
- Working with Flat files
- Mapping Variables and parameters
- Shared folder and Shortcuts
- Version control
- File Repository OR
- File List
- Tracing levels and differences
- Session Properties
- Workflow Properties
- Touch File
- Event wait Task
- Timer Task
- Email task
- Event Raise Task
- Command Task
- Control Task
Reviews
Be the first to write a review about this course.
Write a Review
We are proud to be one of the leading IT online training providers in the industry. We are into online training with much passion and dedication from many years. The expertise we acquired through this helped us to improve our skills in delivering our services. Our trainers with real time experience and skills in online training are dedicated towards producing quality learning. Our unique techniques of online training are recognized throughout the globe and are adopted by most. With Hamsini Technologies you can master any software tool and technology.
Our Training Highlights
Our Training Highlights
- Very interactive and career oriented sessions
- Goal oriented, comprehensive training based on your specific learning needs
- 24X7 Server Access to practice whenever and wherever
- Recorded Sessions for your reference even after the course completion
- 24X7 technical support team via Phone, Email
- Unlimited access to Digital Library to master your course.