Informatica PowerCenter Training
The key feature of this course is to talking about well maintained and structured software development and service companies, one name that stands out is Informatica. You’ll learn and understand about the basic concepts of data warehouse, how to use the Informatica PowerCenter ETL tool in real time project scenarios, understand real time client-server architecture, clear understanding of Informatica PowerCenter architecture and it’s components, understand Informatica ETL developer roles and responsibilities, Interview questions & answers and many other daily course materials.
Why this training is different than others?
Informatica 10.2 Hands on Explanation and Practice
Practice and Realtime Explanation
- Day to Day Explanation on Real-time Mappings/workflows
- Flexible timing, we have two live sessions per day, you can chose any of the timings as per your preference.
- Interactive 2 hours live sessions with doubt solving sessions after session.
- For each topic, mapping document (Business Requirement) will be created and Informatica mapping will create on live session based on the mapping document.
- Interview questions on each topic will be covered on daily basis and provided to the candidate. CLICK HERE to checkout our stack of interview questions.
- 40+ Realtime Mappings will cover with Explanation and implementation.
- Oracle and UNIX Topics covered
- Realtime Project Document Explanation
- Resume building on Informatica
- Informatica Cloud IICS-IDMC Basics
- Interview questions and Tips
Upcoming Batch Schedule
Raj Informatica provides flexible timings to all our students. Here are the Informatica Training Class Schedules in our branch 8. If this schedule doesn’t match please contact us for better options.
21st Batch Starting 8th December 2023
35 Days Course (2 hours) Online Live Session Course
Informatica Course Syllabus
Course Duration: 70 Hours to 80 Hours (30 to 35 days)
Software Installation: Oracle Database 11g Express Edition, Informatica 10.2 Server and Client Components, SQL Server
Take Away: PDFs on daily basis will Sample Data Model and sample case study
Class Delivery: Live Online Meeting (Interactive LIVE Web Based)
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 / Un connected 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 Dymanic Lookup
- Fact loading
- Mapping variables and Parameters.
- Incremental Loading (Real time Explanation)
- Versioning (Real time Explanation)
- Different repositories 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
Course Instructor
Mr. Nataraj V (Raj)
I'm a Business Intelligence Consultant with 12+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies.
YouTube Reviews
Linkedin Reviews
Google Reviews
Training Course Reviews
