L'Obel Data Warehousing Training

Certificate Program Provided by L'Obel IT-Palaestra L'Obel Certified Data Warehousing Training L'Obel's Data Warehousing Training course will help you acquire advanced skills for becoming a skilled Data Warehousing Specialist. Internship Options L'Obel ITP is unique in its Data warehousing Training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous INTERNSHIP in its DATA WAREHOUSING SOFTWARE DEVELOPMENT CENTER. This gives the participant real time Data Warehousing experience through Software Development Life Cycle to making him/ her a complete Data Warehousing Professional. DATA WAREHOUSING@L'Obel is designed to make the participant the most sought after Data warehousing Expert. This makes the participant familiar with the most popular tools and technologies in Data warehousing. On completion of this course the participant can join the industry as a Data warehousing Consultant/ Specialist. Course Syllabus DATA WAREHOUSING CONTENTS * What is Data warehouse? * Characteristics of Data warehouse. * What is Data warehousing? * Principles of Data warehouse. * Benefits of Data Warehousing. * What is Online transactional systems (OLTP)? * Difference between OLTP and Data Warehousing. * Architecture of Data Warehousing. * HPQS. * Approaches of Data warehousing. * Normalization and Denormalization. * Data Warehousing Lifecycle: * Data Modeling * Dimension table * Fact Table * Aggregate table * Schemas * Star schema * Snowflake schema * Types Of Fact Tables: * Cumulative * Snapshot * Fact less Fact * Types Of Facts: * Additive * Semi Additive * Non Additive * Confirmed Dimension * Confirmed Fact * Degenerated Dimension * Casual Dimension * ODS * Cube * Hierarchies * Slowly changing Dimension Concepts * OLAPa s Erwin * Getting Started * Erwin Workplace * Model Explorer * Dockable Toolbars * Stored Display Tabs * Basic Data Model Objects * Identifying * Non-identifying * Display Levels * Subject Area * Indexes INFORMATICA * Introduction to Informatica * Products of Informatica * Difference between Power mart and Power center * Installation of Informatica * Configuring Informatica * Configuring Informatica Repository Server * Creating & Configuring Repository * Configuration Informatica Server * Configuration Temp Server(Workflow Manager) * Informatica Architecture * Informatica Client Tools * Designer (Components) * Source Analyzer * Workflow Manager (Components) * Workflow Monitor * Repository Manager * Repository Server Admin Console * Informatica Server Tools * Repository Server * Server * Transformations * Source Qualifier * Filter * Expression * Aggregator * Joiner * Router * Rank * Sorter * Sequence Generator * Union * Xml Source Qualifier * Lookup (Connected/ Unconnected) * Stored Procedure (Connected/ Unconnected) * Update Strategy * Transaction Control * Normalizer * Application Source Qualifier * Application multi-group Source Qualifier * Custom * Mapplet Input * Mapplet Output * Midstream XML Generator * Midstream XML Parser * Concepts * SQL Override * Working with files (Sources, Target) * File Repository Concept * Constrained Based Loading * Parameters * Mapping Parameters * Mapping Variables * Session Parameters * Incremental Aggregator * Application Source Qualifier * Debugging * Slowly Changing Dimension BUSINESS OBJECTS * BO Reporting Tool * The Query Panel * Turning Tables to chart * Formatting Cells/ Tables * The Structure View * Insertion of Rows or Columns * Breaks * Sections * Ranking * Filter * Alerters * Crosstabs * Grouping * Slice ? and - Dice * Drill * Exporting Data * Data Providers * Master/ Detail Reports * Introduction to BO Designer * Simple Universe and Object Creation * Creating Hierarchy * Resolving Loops and SQL Problems * Supervisor BUSINESS OBJECTS * Introduction to Webintelligence * Getting started with Infoview * Viewing Documents in Infoview * Creating New Documents with queries * Restricting Data returned by a Query * Displaying information in different ways * Enhancing report presentation * Formatting reports * Creating Formulae and Variables COGNOS * Cognos Impromptu * Power play Window * Transformer Cognos Reportnet * Cognos Reportnet an Architecture * Cognos connection * Report studio * Query studio * Frame work manager Course Duration The duration of the Data Warehousing course is 140 Hours. Contact us For more information about this Data Warehousing course write to info@lobelitp. com or walk into our IT Training centers located in Bangalore.

L'Obel Data Warehousing Training L'Obel Certified Data Warehousing Professional

L'Obel's Data Warehousing Training course will help you acquire advanced skills for becoming a skilled Data Warehousing Specialist.

Internship Options
L'Obel ITP is unique in its Data warehousing Training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous INTERNSHIP in its DATA WAREHOUSING SOFTWARE DEVELOPMENT CENTER. This gives the participant real time Data Warehousing experience through Software Development Life Cycle to making him/ her a complete Data Warehousing Professional.

DATA WAREHOUSING L'Obel is designed to make the participant the most sought after Data warehousing Expert. This makes the participant familiar with the most popular tools and technologies in Data warehousing. On completion of this course the participant can join the industry as a Data warehousing Consultant/ Specialist.

Course Syllabus

DATA WAREHOUSING CONTENTS

* What is Data warehouse?
* Characteristics of Data warehouse.
* What is Data warehousing?
* Principles of Data warehouse.
* Benefits of Data Warehousing.
* What is Online transactional systems (OLTP)?
* Difference between OLTP and Data Warehousing.
* Architecture of Data Warehousing.
* HPQS.
* Approaches of Data warehousing.
* Normalization and Denormalization.
* Data Warehousing Lifecycle:
* Data Modeling
* Dimension table
* Fact Table
* Aggregate table
* Schemas
* Star schema
* Snowflake schema
* Types Of Fact Tables:
* Cumulative
* Snapshot
* Fact less Fact
* Types Of Facts:
* Additive
* Semi Additive
* Non Additive
* Confirmed Dimension
* Confirmed Fact
* Degenerated Dimension
* Casual Dimension
* ODS
* Cube
* Hierarchies
* Slowly changing Dimension Concepts
* OLAPa s

Erwin

* Getting Started
* Erwin Workplace
* Model Explorer
* Dockable Toolbars
* Stored Display Tabs
* Basic Data Model Objects
* Identifying
* Non-identifying
* Display Levels
* Subject Area
* Indexes

INFORMATICA

* Introduction to Informatica
* Products of Informatica
* Difference between Power mart and Power center
* Installation of Informatica
* Configuring Informatica
* Configuring Informatica Repository Server
* Creating & Configuring Repository
* Configuration Informatica Server
* Configuration Temp Server(Workflow Manager)
* Informatica Architecture
* Informatica Client Tools
* Designer (Components)
* Source Analyzer
* Workflow Manager (Components)
* Workflow Monitor
* Repository Manager
* Repository Server Admin Console
* Informatica Server Tools
* Repository Server
* Server
* Transformations
* Source Qualifier
* Filter
* Expression
* Aggregator
* Joiner
* Router
* Rank
* Sorter
* Sequence Generator
* Union
* Xml Source Qualifier
* Lookup (Connected/ Unconnected)
* Stored Procedure (Connected/ Unconnected)
* Update Strategy
* Transaction Control
* Normalizer
* Application Source Qualifier
* Application multi-group Source Qualifier
* Custom
* Mapplet Input
* Mapplet Output
* Midstream XML Generator
* Midstream XML Parser
* Concepts
* SQL Override
* Working with files (Sources, Target)
* File Repository Concept
* Constrained Based Loading
* Parameters
* Mapping Parameters
* Mapping Variables
* Session Parameters
* Incremental Aggregator
* Application Source Qualifier
* Debugging
* Slowly Changing Dimension

BUSINESS OBJECTS

* BO Reporting Tool
* The Query Panel
* Turning Tables to chart
* Formatting Cells/ Tables
* The Structure View
* Insertion of Rows or Columns
* Breaks
* Sections
* Ranking
* Filter
* Alerters
* Crosstabs
* Grouping
* Slice ? and - Dice
* Drill
* Exporting Data
* Data Providers
* Master/ Detail Reports
* Introduction to BO Designer
* Simple Universe and Object Creation
* Creating Hierarchy
* Resolving Loops and SQL Problems
* Supervisor

BUSINESS OBJECTS

* Introduction to Webintelligence
* Getting started with Infoview
* Viewing Documents in Infoview
* Creating New Documents with queries
* Restricting Data returned by a Query
* Displaying information in different ways
* Enhancing report presentation
* Formatting reports
* Creating Formulae and Variables

COGNOS

* Cognos Impromptu
* Power play Window
* Transformer

Cognos Reportnet

* Cognos Reportnet an Architecture
* Cognos connection
* Report studio
* Query studio
* Frame work manager

Course Duration

The duration of the Data Warehousing course is 140 Hours.

Contact us

For more information about this Data Warehousing course write to info lobelitp. com or walk into our IT Training centers located in Bangalore.

About The Training Provider: L'Obel IT-Palaestra

More Data Warehousing Bangalore Training from L'Obel IT-Palaestra

• L'Obel Certified Ab-initio Training
• L'Obel Certified Abinitio Training
• L'Obel Certified BI Training
• L'Obel Certified Business Objects BO Training
• L'Obel Certified Cognos Training
• L'Obel Certified Data Warehousing Training
• L'Obel Certified DataStage Training
• L'Obel Certified Erwin Training
• L'Obel Certified Hyperion Training
• L'Obel Certified Informatica Training
• L'Obel Certified MicroStrategy Training
• L'Obel Certified TeraData Training