Price: Free


Best institute for informatica training and placement in chennai

******************Greens Technology***************************




The Course teaches the fundamentals ofInformaticaPower center 8.x platform, throughonline trainingand numerous hands-on lab exercises. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them successful Power center developers.

Course Duration:30 hours

Prerequisites:SQL Basics.Software:Informatica, Oracle, Toad

Data Warehouse Concepts:

·  Introduction to Data warehouse

·  What is Data warehouse and why we need Data warehouse

·  OLTP vs ODS vs Data warehouse

·  Dimensional modeling

·  Star schema/Snowflake schema/Galaxy schema

·  Dimensions / Facts tables.

·  Slowly Changing Dimensions and its types.

·  Data Staging Area

·  Different types of Dimensions and Facts.

·  Data Mart vs Data warehouse

·  DWH Approaches: Ralph Kimball’s vs Bill Inmon’s

Informatica Power Center 8.x:

Software Installation:

Informatica 8.x Server/Client Installation on Windows/Unix.

Power Center Architecture and Components:

·  Introduction to informatica Power Center

·  PowerCenter 8.x architecture

·  PowerCenter 7 architecture vs PowerCenter 8 architecture

·  Extraction, Transformation and loading process

·  Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager.

·  Repository Server and agent

·  Repository maintenance

·  Repository Server Administration Console

·  Security, Repository, privileges and folder permissions

·  Metadata extensions

Power Center Developer Topics:

Lab 1-Create a Folder.

Lab 2-Analyze Source Data, Import Source.

Lab 3- Import Targets

Lab 4–Create a Mapping, session, and workflow

Lab 6– Start and Monitor a Workflow

Lab 7–The Debugger

Lab 8- Expression and Filter

Lab 9– Aggregator, Heterogeneous join

Lab 10– Sorter

Lab 11– Basic Lookup

Lab 12– Deleting Rows

Lab 13– Data Driven Inserts and Rejects

Lab 14– Router

Lab 15– Straight Load

Lab 16– Conditional Lookups

Lab 17– Heterogeneous Targets

Lab 18– Mapplets

Lab 19 –Reusable transformations

Lab 20– Dynamic Lookup

Lab 21– Sequential Workflow

Lab 22– Error handling fatal and non Fatal

Lab 26- Override Mapping Variable with Parameter Files

Lab 27– Dynamically Updating a Source Qualifier with Mapping Variable

Lab 28– SCD 1, 2, 3

Lab 29– Create Worklets using Tasks

Lab 30 :PMCMD

Lab 31: Informatica Project- Case Study


Greens Technology

Contact person:- Anbu

Mobile : 9840496320/9940516384

No11 1st padmanabhan nagar,Adyar,Chennai 600020.

Best Informatica Training in chennai

Excellent Informatica Training in chennai

Best Informatica Training

Real Time Informatica Training in chennai

Best institute for Informatica Training in Chennai

Best Informatica Training with certification

Best Informatica Training with placement in chennai


More Details

Total Views:44
Reference Id:#147269
Phone Number:9940516384
Website URL:Click To Visit
Current Rating: /5 0 Vote


Copyright © 2020 |   All Rights Reserved | |   24x7 support |   Email us : info[at]