Program Calendar
-
Available Dates
Live Virtual Training
-
28 December, 2024
-
19:00 - 23:00 IST
-
Weekend
Live Virtual Training
-
4 January, 2025
-
19:00 - 23:00 IST
-
Weekend
Live Virtual Training
-
11 January, 2025
-
19:00 - 23:00 IST
-
Weekend
-
28 December, 2024
19:00 - 23:00 IST
Weekend
Course Overview
Informatica Training will train you on how to administer the tool efficiently, and to upgrade your skills to the
latest version. This Informatica Certification course provides you the overview of Informatica PowerCenter Product
and its installation, the concepts of data integration and data warehousing. You will learn how different
development units of PowerCenter can be used to create a simple mapping. The Informatica Certification Course
introduces you to advanced transformation techniques, and ETL scenarios using Informatica 10.
You will
understand the features provided by Informatica to debug, troubleshoot and handle errors. You will learn the best
practices for optimum performance of your ETL process & to manage the repository effectively. An overview of the
PowerCenter administration console is given, and you will recognize and be able to explain integration and
repository service properties. The Informatica Training Course will also deal with command line aspect of
Informatica PowerCenter 10.
What you will Learn
- In-depth knowledge of the Informatica PowerCenter, its Architecture, and Environment
- Comprehensive knowledge of various tools like Informatica Administrator Suite, Repository Manager, Designer and Workflow Manager
- Capability to load Dimension Tables, use Advanced Transformation, recognize and repair Connection & Network Errors, configure Workflows & Sessions, create Users and Group and design Error Handling strategies
- Hands-on knowledge of Informatica PowerCenter command line tools
- The exposure to many real-life industry-based Business Intelligence Projects
- Rigorous involvement of an SME throughout the Informatica Training to learn industry standards and best practices
Prerequisites
There are no prerequisites for learning Informatica Course in general. However, having knowledge of SQL will be beneficial, but certainly not a mandate.
Course Curriculum
-
Topic Covered:
- Informatica & Informatica Product Suite
- Informatica PowerCenter as ETL Tool
- Informatica PowerCenter Architecture
- Component-based development techniques
-
Topic Covered:
- Data Integration Concepts
- Data Profile and Data Quality Management
- ETL and ETL architecture
- Brief on Data Warehousing
-
Topic Covered:
- Visualize PowerCenter client tools
- Data Flow
- Create & execute mapping
- Transformations & their usage
-
Topic Covered:
- PowerCenter Workflow Manager
- Flow within a Workflow
- Reusability & Scheduling in Workflow Manager
- Components of Workflow Monitor
- Workflow Task and job handling
-
Topic Covered:
- Advanced transformations (Java, SQL, Normalizer)
- XML File Processing & Transaction Processing
- Error handling features
- Cleaning the data (Advanced Functions, Regular Expressions)
- Reusability features
-
Topic Covered:
- Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
- Advanced techniques – Flat File, XML File
- Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
-
Topic Covered:
- PowerCenter Error
- Basic troubleshooting methodology
- Debugger
- Workflow and Session logs to diagnose errors
- Connection Errors & Network errors
- Recovery scenarios & mechanisms
- Configure workflow & sessions for recovery
- High Availability
- PowerCenter Environment
-
Topic Covered:
- Performance Tuning Methodology
- Mapping design tips & tricks
- Caching & Memory Optimization
- Partition & Pushdown Optimization
- Design Principles & Best Practices
-
Topic Covered:
- Repository Manager tool (functionalities, create and delete, migrate components)
- PowerCenter Repository Maintenance
-
Topic Covered:
- Features of PowerCenter 10
- Overview of the PowerCenter Administration Console
- Integration and repository service properties
- Services in the Administration Console (services, handle locks)
- Users and groups
-
Topic Covered:
- Infacmd, infasetup, pmcmd, pmrep
- Automate tasks via command-line programs
-
Topic Covered:
- Informatica 10 Architecture
- Application services
- Buffer memory
- Connectivity among the tolls
- Connection Pooling
+91 8447121833
Available 24x7 for your queries
FAQs
Training Features
Experiential Workshops
Top-rated instructors imparting in-depth training, hands-on exercises with high energy workshop
Certificate Exam Application Assistance
The training program includes several lab assignments, developed as per real industry scenarios.
Certificate Exam Success Formula
Training begins taking a fresh approach from basic, unique modules, flexible, and enjoyable.
Certificate Journey Support
Basic to intermediate and eventually advanced practicing full hands-on lab exercises till you master.
Free Refresh Course
Refresh training for experts for mastering and enhancing the skills on the subjects with fresh course modules.
Exclusive Post-Training Sessions
Includes evaluation, feedback, and tips to handle critical issues in live setup after you are placed in a job.
Mildain's Master Certificate
Earn your certificate
This certificate proves that you have taken a big leap in mastering the domain comprehensively.
Differentiate yourself with a Masters Certificate
Now you are equipped with real-industry knowledge, required skills, and hands-on experience to stay ahead of the competition.
Share your achievement
Post the certificate on LinkedIn and job sites to boost your profile. Notify your friends and colleagues by sharing it on Twitter and Facebook.
