Informatica PowerCenter Training
- Offered byACTE
Informatica PowerCenter Training at ACTE Overview
Duration | 40 hours |
Total fee | ₹11.52 Lakh |
Mode of learning | Online |
Credential | Certificate |
Informatica PowerCenter Training at ACTE Highlights
- Earn a certificate after completion
Informatica PowerCenter Training at ACTE Course details
- ACTE Informatica PowerCenter Training provides a strong foundation on all the core concepts of Informatica PowerCenter Powercenter to create, execute, administer, and schedule ETL processes and understand how these are used in data warehouse and data mining operations
- This course will make you proficient in working with administrator console, repository manager, workflow manager, advanced transformations, etc
Informatica PowerCenter Training at ACTE Curriculum
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
Power Center Components
Designer
Repository Manager
Workflow Manager
Workflow Monitor
Informatica PowerCenter Concepts and Overview
Informatica PowerCenter Architecture.
Source Qualifier
Target Designer
Transformations
Mappings
Mapplets
Sessions
Sources
Working with relational Sources
Working with Flat Files
Targets
Working with Relational Targets
Working with Flat file Targets
Transformations
Expression Transformation
Lookup Transformation
Sequence Generator Transformation
Filter Transformation
Joiner Transformation
Sorter Transformation
Procedural Transformation
Router Transformation
Power Center Transformation Language
Numeric functions
String Functions
Date Functions
Conversion Functions
Cleansing Functions
TYPES Of LookUp Caches
Static LookUp Cache
Dynamic LookUp Cache
Persistence lookup Cache
Shared LookUp Cache
Sorter and Rank Cache
Task Types
Session
Command
Timer
Event Wait
Event Raise
Decision
ETL Testing
UNIT Testing
System Integration testing
PERFORMANCE TESTING
ETL Performance Optimization techniques
Other courses offered by ACTE
Student Forum
Anything you would want to ask experts?
Informatica PowerCenter TrainingUseful Links
Know more about ACTE
Know more about Programs
- Engineering
- Information Technology
- Instrumentation Technology
- Food Technology
- Aeronautical Engineering
- Artificial Intelligence and Machine Learning
- Metallurgical Engineering
- MTech in Computer Science Engineering
- VLSI Design
- Petroleum Engineering
- Aerospace Engineering
- BTech in Biotechnology Engineering
- Pharmaceutical engineering
- Silk Technology
- Microelectronics