Infitech Certified Data Warehousing

Infitech’s Data Warehousing course will help you acquire advanced skills for becoming a skilled Data Warehouse Specialist.

Internship Options
Infitech Global is unique in its 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 SOFTWARE DEVELOPMENT CENTER. This gives the participant real time software-development experience through Software Development Life Cycle to making him/her a complete Software Professional.

DATAWAREHOUSING@infitech is designed to make the participant the most sought after Datawarehousing Expert. This makes the participant familiar with the most popular tools and technologies in Datawarehousing. On completion of this course the participant can join the industry as a Datawarehousing Consultant/Specialist.

Course Syllabus

DATAWAREHOUSING CONTENTS

• What is Data warehouse?                                              
• Characteristics of Data warehouse.                    
• What is Data warehousing?                                
• Principles of Data warehouse.                            
• Benefits of DWH.                                                          
• What is Online transactional systems (OLTP)?
• Difference between OLTP and DWH.                              
• Architecture of DWH.                                        
• HPQS.                                                                          
• Approaches of Data warehousing.                                  
• Normalization and Denormalization.                               
• DWH 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
• OLAP’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 course write to queries@infitechglobal.com or walk into our IT Training centers located in Chennai & Bangalore.

For more details click here - Locate a center