India: +91 90300 10123

Whatsapp:+1 516 8586 242

India: +91 40 6050 1418

USA: +1 909 233 6006

UK: +44 (0)203 371 0077

Data Warehouse Concepts Online Training

Data Warehouse Concepts Course Content

Datawarehouse Concepts
  • Data Warehouse
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture (Basic)
  • Data Warehouse Architecture
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Dimension
  • Fact
  • Slowly Changing Dimension
  • Hierarchy
  • Confirmed Dimension
  • Fact less Fact
  • Summary / Aggregations table
  • Change Data capture
E T L Informatica Power Center 8.1
Power Center Component
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
Informatica Overview & Concepts
  • Informatica Architecture
  • Source Qualifier
  • Target Qualifier
  • Transformation
  • Mappings
  • Mapplets
  • Sessions
  • Tasks
Sources
  • Working with relational Source
  • Working with Flat Files
Targets
  • Working with Relational Targets
  • Working with Flat file Targets
Transformations
  • Expression
  • Lookup
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Procedural
  • Router
  • Aggregator
  • Active & Passive Transformations
  • Update Strategy
  • Data Concatenation
  • Debugging the Mappings
Mappings & Mapplets
  • Mapping Variables & Parameters
  • Creating Cubes & Dimensions
  • Working with the Mapping Wizards
Workflow Manger
  • Server Architecture
  • Workflows, Worklets & Sessions
  • Tasks, Assignments, Events, Command etc
Tuning Performance
  • Informatica Tuning (Source, target, mapping & Session)
  • Oracle Tuning (Indexes)