Informatica PowerCenter
Informatica PowerCenter is a powerful data integration and transformation tool that enables organizations to integrate, cleanse, and transform data from various sources into a unified view. This course is designed to provide students with the necessary skills and knowledge to effectively use Informatica PowerCenter for data integration and transformation.
Course Key Learning:
1. Understanding the PowerCenter architecture and components
2. Creating and managing workflows, transformations, and sessions
3. Working with source and target databases using various connectors
4. Implementing data cleansing techniques using Informatica’s built-in functions and rules
5. Performing data transformation using mapping, expressions, and functions
6. Implementing data quality rules using Informatica’s Data Quality module
7. Implementing data security using PowerCenter’s security features
8. Monitoring and managing PowerCenter jobs using the PowerCenter console
9. Performing data migration using PowerCenter’s Migration Manager
10. Understanding PowerCenter’s best practices for performance optimization
Course Content:
Module 1: Informatica PowerCenter Concepts and Overview
- Informatica PowerCenter Architecture.
- Source Qualifier
- Target Designer
- Transformations
- Mappings
- Mapplets
- Sessions
- Tasks
Module 2: Data Warehousing Concepts
- Data Warehouse
- Data Mart
- OLAP VS OLTP
- Data Warehouse Architecture (Basic)
- Data Warehouse Architecture (with a Staging Area)
- Dimensional Modeling
- Star Schema
- Snowflake Schema
- Dimension
- Fact
- Slowly Changing Dimension(Type 1,2 and3)
- Hierarchy
- Confirmed Dimension
- Fact less Fact Table.
- Summary / Aggregations table
- Change Data capture
Module 3: Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
Module 4: Sources
- Working with relational Sources
- Working with Flat Files
Module 5: Targets
- Working with Relational Targets
- Working with Flat file Targets
Module 6: Transformations
- Expression Transformation
- Lookup Transformation
- Sequence Generator Transformation
- Filter Transformation
- Joiner Transformation
- Sorter Transformation
- Procedural Transformation
- Router Transformation
- Aggregator Transformation
- Update Strategy Transformation
- Union Transformation
- Rank Transformation
- Transaction Control Transformation
- Normalizer Transformation
- Source Qualifier Transformation
- Stored Procedure Transformation
- XML Source Qualifier Transformation
- Debugging Mappings
Module 7: Power Center Transformation Language
- Numeric functions
- String Functions
- Date Functions
- Conversion Functions
- Cleansing Functions
- Aggregate Functions
- User Defined Functions
Module 8: ADVANCED Informatica PowerCenter CONCEPTS
- Unconnected lookup Transformation
- Unconnected Stored Procedure to Create and Drop Index
- Mapplet and Types of Mapplets
- Defining Reusable Transformations.
- User Defined Functions
- Tasks And Types of Tasks
- Worklet and Types of Worklets
- Scheduling Work flow
- Constraint Based Load Ordering
- Target Load Plan
- Types of Batch Processing
- Link conditions
- Mapping Parameters
- Mapping Variables
- Defining Session Parameters
- Session Recovery
- Difference Between Normal and Bulk Loading
- Push Down Optimization
- PMCMD Utility
- PMREP Utility
- Incremental Aggregation
Module 9: TYPES Of LookUp Caches
- Static LookUp Cache
- Dynamic LookUp Cache
- Persistence lookup Cache
- Shared LookUp Cache
- Sorter and Rank Cache
Module 10: Task Types
- Session
- Command
- Timer
- Event Wait
- Event Raise
- Decision
- Assignment
- Control
- Worklet
Module 11: ETL Testing
- UNIT Testing
- System Integration testing
- PERFORMANCE TESTING
- ETL Performance Optimization techniques
Who’s this course for?
- Business intelligence
- ETL
- SQL
- Database professionals
- Project managers
- Graduates looking to make a career in BI
Job Interview Questions
- PHP + MYSQL Job Interview Questions & Answers
- Data Sciences Job Interview Questions and Answers
- Machine Learning Job Interview Questions
International Student FEE : US1000$
Stay connected even when you’re apart
👬🏻Join our WhatsApp Channel – Get discount offers
🧮 500+ Free Certification Exam Practice Question and Answers
Internships, Freelance and Full-Time Work opportunities
👫🏻 Join Internships and Referral Program (click for details)
👫🏻 Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Informatica DataQuality Training IDQ
ETL with Microsoft SQL Server Integration Services (SSIS)
Oracle Big Data Master (Data Integrator – Hadoop, ETL, MapReduce, Apache Spark)
SQL Server Database Administration (SQL Server DBA)
KEY FEATURES
Register Now
