• 22149 members and growing...
INFORMATICA ONLINE TRAINING AT HYDERABAD
Views:817
Published on :Feb 05,2016
Contact Details :
SANDSYS TECHNOLOGIES
2ND FLOOR, ADHITYATRADE CENTRE, MYTRIVANAM, AMEERPET, HYDERABAD

Ph:040 40033103
9573408188

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


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 Override in source qualifier Transformation and lookup Transformation
o Connecting the Target
o Connecting Transformations
o Creating a Mapping
o Completing the Mapping
o Creating a Pass-Through Mapping
o Creating a Mapping with SCD Type 1 and SCD Type 2
o Creating a Mapping with Aggregate Values
o Target load order plan
o Mapping wizards
o Reusable Transformation
o Mapplet overview and usage
• WORKFLOW MANAGER
o Creating the Session
o Creating the Workflow
o Using the workflow manager
o Creating Sessions and Workflows
o Constraint base loading
o Configuring Database Connections in the Workflow Manager
o Creating a Reusable Session
o Creating a Workflow
o Running and Monitoring Workflows
o Opening the Workflow Monitor
o Workflow Tasks
o Session
o Assignment task
o Link task
o Event raise task
o Event wait task
o Timer task
o Post session and Pre-session commands
o Session recovery
o Commit points
o Creation of Parameter file
o Mapping and session parameter
o Performance tuning in ETL
o Various optimization techniques
o P



There are no Reviews for this Listing
Sponsored Ads
Counsellor for Overseas Education

Providing customized and up to date career concepts keeping in view the individual profile and the ever changing market scenario, believe in us to help you to make the right and the best career ...

Fast, Reliable Bulk SMS Solution, SMS API In India  "9Nodes - Bulk SMS Solutions Provider". 9Nodes is a leading Bulk SMS service provider, delivering to all networks in India. 9Nodes incorporated in the year 2007 by Evolgence IT Systems, has its headqu...
150 Sq.Yrds Plot for Sale

Features

  • Near Pendurthi Junction, Very Near to all emenities like school, college, city bus stand, Vegetable Market, Hospital, etc
  • Borewell with Foundat...
kosmik

kosmik

Online Training for .NET-MSBI-Cloud Computing

We are a pool of highly experienced software professional with an average 12yrs industry experience and based at hyderabad. We are offering online training on .NET, Windows Azure,MSBI (SSAS,SSIS...