Price: Free

Description

Best institute for informatica training and placement in chennai


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


**********Contact:-Anbu******(9840496320/9940516384)***********


INFORMATICA POWER CENTER 8.X Course Content:


Description:


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:7
Reference Id:#147268
Phone Number:9940516384
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2019 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com