Informatica classroom/online with job oriented best coaching in Sandsys with live projects by Real-Time experts and low fees.
Course Name Informatica
Demo Classes Morning & Evening In Week Days
Venue Sandsys Technologies

Trainer Having 7+ years of experience

MODE OF TRAINING      : NORMAL TRACK                  FAST TRACK                    ONLINE
DURAION       : 30 DAYS                          15 DAYS                   30 Days
DAILY SESSION                     : 1hr 30min                        2hr 30min                  1hr 30min
LAB SESSION       : 7AM – 9PM
SOFTCOPY OF MATERIAL AND SOFTWARES
REAL-TIME PROJECT WITH EXPLANATION
          100% JOB ASSURANCE

CONTENT
DATAWAREHOUSING CONCEPTS:
• Introduction to Datawarehousing
• Data Modelling(Schemas, FACTS and DIMENSIONS)
• Slowly Changing Dimensions
• Metadata
INFORMATICA POWERCENTER 8.6 COURSE CONTENTS
• INFORMATICA OVERVIEW
o History of Informatica
o Opportunities of Informatica
o Other ETL tools
o Power center Administration
o Informatica Power center architecture
o Power center components
o ETL Plan
o Power center Clients
o Designer
o Workflow manager
o Work Flow monitor
o Workflow manager
o Repository manager
o Power center repository
o Administrative tool
o Repository services
o Integration services
o Power center domain
o Application services
o Concept of nodes and grid
o Service manager
o Power center administration console
o Repository Administration
o Creating Repository Users and Groups.
o Connecting to the Repository.
o Creating a Group
o Assigning Privileges to a Group.
o Creating a User
o Creating a Folder
o Folder Permissions
• DESIGNER
o Types of Transformations
o Connected and Unconnected Transformations
o Active and Passive Transformations
o Creating Source Tables
o Creating Target Definitions
o Creating Target Tables
o Creating source definitions
o Creating a Mapping
o Connecting Transformations
o Transformation Creation
o Importing sources and targets (database objects)
o Importing sources and targets (flat files and XML files)
o Using Transformations
o Aggregator Transformation
o Expression Transformation
o Lookup Transformation (Connected and Un Connected)
o Union Transformation
o Joiner Transformation
o Filter Transformation
o Sequence Generator Transformation
o Stored Procedure Transformation
o Source Qualifier Transformation
o Router Transformations
o Rank Transformations
o Update Strategy Transformation
o XML Transformation
o SQL Ov