Course Features
Raj’s Informatica 10.2 Real-time Job Based Training
Instructor: RAJ (Nataraj)
Experience : 11+ years
Location: Bangalore (Currently working on Informatica)
Demo Class
Course Description
Raj’s Informatica 10.2 Real-time Job Based Training
This training program is designed to prepare the candidates for Informatica 10.2 ETL Developer. This Informatica PowerCenter Job based Training for Developers 10.2 course teaches advanced mapping techniques and performance tuning, and provides a thorough review of Versioning Concepts found in PowerCenter version 10.2. After completion of this course, you are equipped with skills needed for Informatica development, Realtime hands on Informatica Development.
Course Duration: 60 to 70 Hours ( 30 to 35 days)
Software Installation: Oracle Database 11g Express Edition, Informatica 10.2 Server and Client Components
Take Away: PPTs on daily basis will Sample Data Model and sample case study
Software Installation: Oracle Database 11g Express Edition, Informatica 10.2 Server and Client Components
Take Away: PPTs on daily basis will Sample Data Model and sample case study
How this training is different than others?
Informatica 10.2 Hands on Explanation and Practice
Practice and Realtime Explanation
- 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
Course Topics
ETL & Informatica
- DWH Concepts
- ETL Overview
- Informatica Overview
- Components of Informatica
- What is Repository?
- Configuring the Domains
- Types of Repositories in Real Time
- Creation of Folders
- 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
- Source Qualifier
- Expression
- Filter
- Router
- Connected / Un connected and Dynamic Lookup
- Lookup Caches
- Rank
- Sorter
- Aggregator
- Joiner
- Sequence Generator
- Union Transformation
- Update Strategy
- Transaction Control
- Normalizer
- Reusable Transformations
- Mapplets
Reusable Objects
Workflow Manager
- Reusable Transformations
- Mapplets
- Worklets
- 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
- Manager Overview
- Source and Target Connection
- Flat File
- ODBC
- Tasks
- Types of Tasks
- Command Task
- Event Wait
- Event Raise
- Timer
- Assignment
- Decision
- Control
- Creating Sessions
- Reusable Sessions
- Creating Workflows
Workflow Monitor
- Monitor Overview
- Workflow Monitor Views
- Running and Monitoring Workflows
- Scheduling
- Workflow and Session Logs