Raj Informatica Training

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

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
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
  • Email
  • 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

Welcome To Raj Informatica

IMPORTANT: If your details are incorrect please update it before joining the course.

Your User ID:

Your Username:

Your Full Name:

Your Registered Email:

Your Phone Number:

- Need To Login/Signup -

- Need To Login/Signup -

- Need To Login/Signup -

- Need To Login/Signup -

- NOT UPDATED -