Informatica Online 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.
18th Batch Evening Class
7:30 PM to 9:30 PM
Starting 7th April 2023
Price: ₹15,000 ₹20,000
Best Informatica Online Training
Our Unique Course Features
- 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.
- Experienced instructor with 11+ years of Informatica PowerCenter experience.
- 600+ 5 star reviews on the course.
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.
35 Days Course (2 hours) Online Live Session Course
Informatica Course Syllabus
- Day to Day Explanation onReal-time Mappings/workflows
- For each topic, mapping document (Business Requirement) will be created and infomatica mapping will create on live session based on the mapping document.
- All Doubts will clear on live sessions.
- Interview questions on each topic will be covered on daily basis and provided to the candidate
- Daily Practice at Home
- Oracle and UNIX Topics covered.
- Realtime Project work Explanation
- Realtime Project Document Explanation
- Resume building on informatica
- Interview questions and Tips
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
Nataraj V (Raj)
I'm a Business Intelligence Consultant with 11+ 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
