D2trainings Posted June 6, 2014 Report Share Posted June 6, 2014 The call is for people who are not looking to get into programming jobs, learn Informatica 9 and venture into Data Warehouse. Our mentor is vastly experienced and is located in USA and has loads of experience in diversified industries. Our training's are interactive,always keeping the students on the edge, which will create an healthy learning experience with timely assignments. Please go through the course content which is mentioned below. COURSE CONTENTS FOR INFORMATICA 9 WITH CASE STUDY DATA WAREHOUSE CONCEPTS Introduction - Need of Data Warehouse - Characteristics of OLTP and OLAP Architecture of Data Warehouse - Definition of Data Warehouse - Dimension and Fact Tables - Star Schema - Snow Flake Schema - Importance of Staging Area - Surrogate KeysSlowly Changing Dimensions (SCD) - SCD Type 1 - SCD Type 2 - SCD Type 3 Types of Dimensions and Fact Tables - Time Dimension - Types of Facts -- Additive, Semi Additive, Non Additive - Factless Fact Table INFORMATICA 9 WITH CASE STUDY Introduction and Architecture -Introduction to Informatica - Architecture of Informatica -- PowerCenter 9 - Informatica Design Process - Informatica Client Tool -- Designer - Source Analyzer and Warehouse Designer Mapping Designer - Create a Simple Mapping - Overview of Transformations - Types of Transformations -- Active and Passive - Expression Transformation - Source Qualifier Transformation - Introduction to Workflow Manager - Task Developer - Workflow Designer - Creating Connections Flat Files Handling - Create Simple Mappings - Flat File Analysis Architecture Review - Architecture 9 Review - Command Task - Create a Mapping - Joiner Transformation Transformations - Create a Mapping - Using Join in a Source Qualifier Transformation - Expression Transformation - Filter TransformationTransformations Contd - Multiple Targets Loading - Router Transformation - Diff Between Filter and Router Transformations - Create a Mapping - Master Outer Join Transformations Contd - Create a Mapping - Reusable Transformation - Lookup Transformation - Debugger - Handling Multiple Files as Source Update Strategy - SCD Type 1 mapping Implementation - Update Strategy TransformationSCD Type 2 - SCD Type 2 mapping Implementation Loading Strategy - Sequential and Parallel Loading - Union Transformation - Dynamic Lookup Cache - Introduction to Fact Loading - Create a Mapping Transformations Contd - Create a Mapping - Lookup Transformation - Persistent Cache - Aggregator Transformation - Sorter Transformation - Creating Stored Procedure Transformations Contd - Normalizer Transformation - Stored Procedure Transformation - Active Vs Passive Transformations - Connected Vs UnConnected Transformations Mapplets - Create Mappings - Sequence Generator Transformation - Multiple Pipelines in a Single Mapping - Target Load Plan - Mapplets Implementing Incremental Loading - Create a Mapping - Importance of Mapping Variable Implementing Incremental Aggregation - Create a Mapping - Incremental Aggregation Transaction and Variable Port - Transaction Control Transformation - Variable Ports Workflow Tasks - Scheduling - Task Link Properties - Event Raise Task - Event Wait Task - Worklet Advance Features in Informatica - Parameter Files - Removing Duplicate Rows - Export and Import on Objects - Performance tuning - Partitioning - Understanding Jobs and Scheduler - Pmcmd - Overview of UNIX scripting For further details: Joseph PH: 609-365-7993 E: [email protected] 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.