-33%
Informatica PowerCenter Online Training
About This Course
ETL & Informatica
- DWH Concepts
- ETL Overview
- Informatica Overview
- Components of Informatica
Repository Manager
- What is Repository?
- Configuring the Domains
- Types of Repositories in Real Time
- Creation of Folders
Informatica Designer
- Overview and Usage
- Tools available in Designer
- Source Analyzer
- Creating Sources
- Generating/Executing SQL
- Types of Sources
- Warehouse Designer
- Creating Targets
- Types of Targets
- Transformation Developer
- Transformation Introduction
- Creating Transformations
- Functions/Constants/Dates/Variables
- Mapping Designer
- Creating Mappings
- Mapplet Designer
- Creating Mapplets
Transformations (Basics)
- Source Qualifier
- Expression
- Filter
- Router
- Connected / Unconnected and Dynamic Lookup
- Lookup Caches
- Rank
- Sorter
- Aggregator
- Joiner
- Sequence Generator
- Union Transformation
- Update Strategy
Transformations (Advanced)
- Transaction Control
- Normalizer
- Reusable Transformations
- Mapplets
Reusable Objects
- Reusable Transformations
- Mapplets
- Worklets
Advanced Topics
- SCD Type -1 Mapping using Statis Lookup
- SCD Type -2 Mappingƒ
- SCD TYPE -1 Using Dynamic Lookup
- Fact loading
- Mapping variables and Parameters.
- Incremental Loading (Real-time Explanation)
- Versioning (Real-time Explanation)
- Different repositories are used in real-time. (Detailed explanation about DEV / QA /Prod Repositories)
- Mini Project – End to End explanation and Practice with Several Sources From Source to Stage, Stage to Dimensions And Dimension to Fact Using Incremental Load , SCD Type-2, and Parameterization
- Copying Objects
- Importing and Exporting Objects
- Performance Tuning
- Bottlenecks
- Parameter Files (Real-time Explanation)
- Dynamic Target File Generation
Workflow Manager
- Manager Overview
- Source and Target Connection
- Flat File
- ODBC
- Tasks
- Types of Tasks
- Command Task
- Event Wait
- Event Raise
- Timer
- Assignment
- Decision
- Control
Sessions and Workflows
- Creating Sessions
- Reusable Sessions
- Creating Workflows
Workflow Monitor
- Monitor Overview
- Workflow Monitor Views
- Running and Monitoring Workflows
- Scheduling
- Workflow and Session Logs
Learning Objectives
Learn ETL best practices using Informatica
Learn debugging, troubleshooting, and error handling using Informatica
Learn Data Warehouse Concepts and ETL Concepts
Learn Mapping Parameter and Variables
Understand Informatica PowerCenter architecture & its different components
Learn to build Mappings, Tasks, and Workflows
Material Includes
- Live Interactive Sessions
- Real-Time Hands-on Training
- Industry Specific Scenario
- Live Coding Practice
- Certification On Completion
- Resume Preparation Guidance
- Career Guidance
- Life Time Access to Recording Sessions
Target Audience
- Software developers
- Analytics professionals
- ETL or Data warehouse professionals
- Graduates who wanted to enter IT field
- Mainframe developers and architects