Informatica PowerCenter (Live Training)
₹12,999.00
₹14,999.00
-
LevelBeginner
-
Duration55 hours
-
Last Updated14 July 2024
-
CertificateCertificate of completion
Hi, Welcome back!
What I will learn?
- In-depth knowledge of Informatica PowerCenter and its role in data integration.
- Hands-on expertise in seamlessly integrating, managing, and governing data across environments.
- Practical skills in orchestrating data workflows and designing efficient data pipelines using PowerCenter's user-friendly interface.
- Techniques for ensuring high data quality and reliability in various enterprise settings through PowerCenter.
- Proficiency in leveraging PowerCenter to optimize data integration projects for enhanced efficiency and effectiveness.
- Understanding of modern data integration strategies and best practices, with a focus on solutions offered by PowerCenter.
Course Curriculum
Informatica PowerCenter Setup
Know how to install Informatica PowerCenter
-
Steps to Install Informatica PowerCenter
Informatica PowerCenter Overview
Get familiarized with Informatica PowerCenter Tool.
-
Why we need Informatica PowerCenter?
-
Informatica PowerCenter Client Components
-
Quiz: Informatica PowerCenter Overview
Datawarehouse Concepts
-
Overview
-
Definition
-
Types of Data Warehouse
-
Database vs Data Warehouse
-
Dimensional Model
-
Types of Dimensions
-
Slowly Changing Dimensions
-
Quiz: Datawarehouse
Transformations Overview
Understand different types of Transformations
-
Learn Transformations
Transformations (Basic)
-
Filter Transformation
-
Quiz: Filter Transformation
-
Assignments: Filter Transformation
-
Source Qualifier Transformation
-
Quiz: Source Qualifier Transformation
-
Assessment: Source Qualifier Transformation
-
Expression Transformation
-
Quiz: Expression Transformation
-
Assignments: Expression Transformation
-
Router Transformation
-
Quiz: Router Transformation
-
Assignments: Router Transformation
-
Sorter Transformation
-
Quiz: Sorter Transformation
-
Assignments: Sorter Transformation
-
Aggregator Transformation
-
Quiz: Aggregator Transformation
-
Assignments: Aggregator Transformation
-
Joiner Transformation
-
Quiz: Joiner Transformation
-
Assignments: Joiner Transformation
-
Union Transformation
-
Quiz: Union Transformation
-
Assignments: Union Transformation
-
Rank Transformation
-
Quiz: Rank Transformation
-
Assignments: Rank Transformation
-
Sequence Generator Transformation
-
Quiz: Sequence Generator Transformation
-
Assignments: Sequence Generator
-
Lookup Transformation
-
Quiz: Lookup Transformation
-
Assignments: Lookup Transformation
-
Lookup Caches
-
Update Strategy Transformation
-
Quiz: Update Strategy Transformation
-
Assignments: Update Strategy Transformation
Mini-Project:1 (using Basic Transformations)
This Mini-Project is focused on applying all the basic mapping transformations.
-
Assignments: Mini-Project 1 (using Basic Transformations)
Transformations (Advanced)
-
Normalizer Transformation
-
Quiz: Normalizer Transformation
-
Assignment: Normalizer Transformation
-
SQL Transformation
-
Quiz: SQL Transformation
-
Assignment: SQL Transformation
-
Stored Procedure Transformation
-
Quiz: Stored Procedure Transformation
-
Assignments: Stored Procedure Transformation
-
XML Source Qualifier Transformation
-
Quiz: XML Source Qualifier Transformation
-
Assignments: XML Source Qualifier
-
XML Generator Transformation
-
Quiz: XML Generator Transformation
-
Assignment: XML Generator Transformation
-
XML Parser Transformation
-
Quiz: XML Parser Transformation
-
Assignment: XML Parser Transformation
-
Transaction Control Transformation
-
Quiz: Transaction Control Transformation
-
Assignment: Transaction Control Transformation
-
Java Transformation
-
Quiz: Java Transformation
-
Assignment: Java Transformation
-
Data Masking Transformation (Theory Only)
-
Quiz: Data Masking Transformation
-
Mapplet in a Mapping
Revision of All Transformations
-
Revise All Transformations
Mapping Parameters, Variables and Parameter file
-
Mapping Parameters, Variables and Parameter file
SCD Type Mappings
-
SCD Type Mappings
Worklet
-
Worklet Overview
Workflow Manager Tasks
-
Workflow Manager Tasks
Performance Tuning
-
Performance Tuning
Miscellaneous Topics
-
Target Load Plan
-
Job Scheduling
-
Versioning (Check-in & Check-Out)
-
Code Migration
-
Debugger in Mapping
Mini Project Work
-
Understanding Project Requirement
-
Conversion of Requirements in to Technical Logic
-
Building Data Integration Jobs
-
Understanding the gaps and getting the results
Job Assistance
-
Resume Building
-
Going through sample Interview questions
-
Mock Interview to understand your proficiency
Type of Data Loads
-
Types of Data Loads
Student Ratings & Reviews
No Review Yet
₹12,999.00
₹14,999.00
-
LevelBeginner
-
Duration55 hours
-
Last Updated14 July 2024
-
CertificateCertificate of completion
Material Includes
- 10 hours on-demand video
- Live Video lectures
- Interactive quizzes
- Hands-on exercises
- Downloadable resources
- Completion certificate
- Full Life time access
- 3 Articles
Requirements
- Rest assured no prior IT or Software knowledge is required
- Basic computer knowledge
- Familiarity with data concepts is Appreciated
Target Audience
- Data professionals aiming to enhance their skills in cloud-based data integration and management, particularly with PowerCenter.
- IT professionals and enterprise architects interested in leveraging PowerCenter for seamless data integration across diverse environments, improving their organization's data management practices.
- Aspiring IT professionals looking to specialize in data integration and management, with a focus on solutions like PowerCenter.
- Individuals seeking practical skills in data integration using Informatica PowerCenter, regardless of their current background or profession.