Informatica PowerCenter Training
(Rating based on 5217 reviews)
UPDATE: 24th Batch Starting, 17th May 2024
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.
+91 81052 96858
Have Queries? Ask our Experts
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 choose any of the timings as per your preference.
- Interactive 2-hour 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 check out our stack of interview questions.
- 40+ real-time mappings will be covered 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 Cloud Technologies provides flexible timings to all our students. Here are the Informatica PowerCenter Training Class Schedules. If this schedule doesn’t match with your availability, please contact us for other options.
24th Batch Starting, 17th May 2024!
35 Days Course (2 hours) Online Live Session Course
Morning Batch (Live)
9:30AM to 11:30AM, IST
Fees: ₹15,000
Registration will start soon!
Evening Batch (Live)
7:30PM to 9:30PM, IST
Fees: ₹15,000
Registration will start soon!
Informatica Course Syllabus
Course Duration: 70 to 80 Hours (30 to 45 days)
Software Installation: Oracle Database 11g Express Edition, Informatica 10.2 Server and Client Components, SQL Server
Take Away: PDFs on a 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.
Like the curriculum? Enrol Now
Login or Sign up using your Google account for fast enrolment and easy access.
Guest
Already paid? click the link blow to access the course
YouTube Reviews
Linkedin Reviews
Google Reviews
Training Course Reviews
Click on the reviews to see the original post
