Tell a Friend


      JAVA(core) Training Details





Mode of Training:

 Regular/Fast Track  

Course Duration:

20 hrs (Class: 1-1.5 hrs)

What we Offer:

* Quality Training            * Flexible Timings

* 24/7 Server Access      * Hands-On Training


Data Warehouse Concepts

  • Introduction to Data warehouse
  • What is Data warehouse and why we need Data warehouse
  • OLTP vs ODS vs Data warehouse
  • Dimensional modeling
  • Star schema/Snowflake schema/Galaxy schema
  • Dimensions / Facts tables.
  • Slowly Changing Dimensions and its types.
  • Data Staging Area
  • Different types of Dimensions and Facts.
  • Data Mart vs Data warehouse
  • DWH Approaches: Ralph Kimball’s vs Bill Inmon’s

Power Center Architecture and Components

  • Introduction to informatica Power Center
  • Difference Between Power Center and Power Mart
  • PowerCenter 9 architecture
  • PowerCenter 7 architecture vs PowerCenter 8 and 9 architecture
  • Extraction, Transformation and loading process
  • Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica

Administration Console:

  • Repository Server and agent
  • Repository maintenance
  • Repository Server Administration Console
  • Security, Repository, privileges and folder permissions
  • Metadata extensions


Additional information