Top Notch Training On Informatica

[sarktech1979]

Training Curriculum:

Notes:

1)      This course was originally designed to help anybody including people not from IT. If you are already familiar with any of the following concepts, they can be removed from the training.

2)      The use cases/examples for informatica powercenter are the best. They will help you understand and apply the business rules using majority of the transformations.

PL\SQL:

·         Basic RDBMS concepts

·         ER Modeling and Normalization.

·         Introduction to SQL

·         DDL

·         DML (Till Order By)

·          Aggregate Functions

·         Group By and Having, Relational Algebra

·          Joins

·          Independent Sub Queries

·          Correlated Sub queries

·          Views

·         Some SQL Functions

·         PL\SQL Blocks and Structures

·         Cursors

·         Analytical Functions

·         Date functions

·         Functions like INSTR , TRUNC , SUBSTR , NVL , DECODE , CASE etcetc

·         Materialized Views

·         Complex queries - Union , Union all , minus , intersect

·         Exists , NOT Exists clause

·         Collect stats

·         Grant and revoke

·         Types on Indexes

·         Types of partitions

·         Hints & Explain plan
 

Project Flow:

·         Stages in the project & Roles involved in each stage.
 

Datawarehousing:

·         OLAP and OLTP

·         Characteristics and Architecture of a Datawarehouse

·         Top Down and Bottom Approach

·         Datawarehouse and Datamart

·         Dimensional Modeling

·         ETL Process and Architecture

·         Star/Snow Flake Schema

·         Types of Facts

·         Types of Dimensions

·         Surrogate Keys

·         Fact Less Fact 
 

InformaticaPowercenter:

·         Informatica Architecture and components

·         Informatica Client Tools

·         Overview of Mappings, Sessions and Workflows

·         Informatica Designer(various Transformations)

·         Workflow Manager and Workflow Monitor

·         Shared folder

·         Short cuts

·         How to migrate code from one env to other

·         PMCMD
 

Case Studies:

·         Incremental Load mapping(Source Qualifier, Update Strategy, Parameters and variables, Router, Look Up)

·         Handling Duplicates mapping(Aggregator, Joiner, Joiner,Filter, comparing to rows in Expression)

·         Dynamic Lookup mapping(Look up)

·         Columns to rows mapping(Normalizer)

·         Rows to Column mapping(Aggregator)

Informatica MDM:

·         ApplicationOveriew- How does it fit into large organizations

·         Schema

·         Data Flow

·         Batch Processes

·         Hierarchy Management

Unix:
 

·         Cover the basic commands

·         Basic shell scripting

 

For details contact:

Sam

PH: 678-439-8525

E: [email protected]