EGB SystemsGet a free Evaluation

Chat Live
 Toll Free No.
Toll Free
  • Package
Our Clients
ubs
american-express
 
More
Testimonials
Justin B Handley ( Director-Narasopa.com) 413-628-0151 "This company has taken a great burden off of my... Next
Informatica
Datawarehousing Fundamentals
  • Datawarehouse Basic
  • Benefits Of DWH
  • OLTP
  • DWH Architecture
  • Normalization, Denormalization
  • DWH Life Cycle
  • Data Modeling
  • Dimension Table
  • Fact Table
  • Schemas
  • Star Schemas
  • Snowflake Schema
  • Types Of Fact Tables
  • Cumulative
  • Snapshot
  • Factless Fact
  • Types Of Facts
  • Additive
  • Semi Additive
  • Confirmed Dimension
  • Slowly Changing Dimension Concepts
  • OLAPS


Informatica (Etl Tool)

Power centre components:
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor


Informatica concepts and overview:
  • Informatica Architecture
  • Source Qualifier
  • Target Qualifier
  • Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks

Transformations:
  • Source Qualifier
  • Joiner
  • Sorter
  • Aggregator
  • Expression
  • Sequence Generator
  • Filter
  • Lookup
  • Stored Procedure
  • Update Strategy
  • Router
  • Mapplet In
  • Mapplet Out
  • Normalizer
  • Rank


Working with workflow manager:
  • Task Developer
  • Worklet Desginer
  • Workflow Designer


Working with powercentre 8:
  • Administration Console Tabs
  • Logs Tab
  • Domain Tab
  • Domain
  • Folders
  • Managing Repository
  • Managing Nodes
  • Basics of Testing
  • WinRunner ( Mercury Interactive)
  • Test Director (Mercury Interactive)
  • Load Runner ( Mercury Interactive)


  • Data ware Housing Basic concepts
  • DWH Architecture& Implementation
  • Logical ware house modeling & schema design
  • Marinating the Data ware house
  • Informatica Power center
  • Informatica Designer


  • Core Java
  • J2EE
  • Struts 2.0
  • HTML
  • Advanced PHP
  • PHP Web Services
  • MySQL
  • AJAX
  • Content Management
  • System


  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Outlook
  • Microsoft Access


  • Adobe Illustrator
  • Adobe Photoshop
  • Adobe Flash
  • Adobe Dreamweaver CS3
  • Adobe InDesign
  • Data Warehousing
  • Business Objects Introduction
  • Business Objects Configuration
  • Universe Design – Metadata Modeling
  • Report Building in Info view – BI Reporting
  • Report Building in Desktop Intelligence


  • Visual Basic.Net
  • ADO.Net
  • C#.Net
  • ASP.Net


  • SQL Server 2005