Data Warehousing Online Training |Data Warehousing Training | +917386622889

Data Warehousing Online Training

Introduction to Data warehousing                                      CLICK HERE FOR ENQUIRY Who needs Data warehouse? Why Data warehouse is required? Types of Systems (i)OLTP (ii) DSS Maintenance of Data warehouse Data warehousing Life cycle Data warehousing Testing Ute Cycle Data warehousing Architecture Source Integration Layer Staging Area Targets Analysis & Reporting HPQS Data Modelling Introduction Different Phases of Modeling Multi Dimensional Modelling What are Facts? Multi Dimensional Model Hierarchies OLAP MOLAP ROLAP HOLAP Cubes and its Functions Star Schema Fact Table Dimensional Tables Snow flake Schema Fact less Fact Table Confirmed Dimensions Data Modelling Tools Forward Engineering Reverse Engineering Update Model, Alter database Complete compare Mapping Source Qualifier as Filter Source qualifier to join Data Filter Transformation Expression Transformation Sequence Generator Transformation Rank Transformation Router Transformation Aggregator Transformation Joiner Transformation Stored procedure Transformation (Connected & Unconnected) Union Transformation XMl Transformation Mapping Wizards Implementing Type-I, Type-II, Type-III Mappings Informatica -workflow Manager Workflow Introduction Tasks Workflow tools Connections Defining tasks (i) Command Task (ii) Email Task ii) Session Task (iv) Link Conditions (v) Event Wait & Event Raise Setting Properties of Session Task Creating Workflow Starting Workflow Monitoring Workflow Informatica Advanced Features Incremental Aggregation Mapplet Implementation Target Load Plan Constraint based Loading Mapping Parameters Session parameters Link Conditions Meta Data Backup & Restore Copying Repository Deleting Repository Sending Notification Messages Business Objects 6.5 with BO-XI Desktop Products Designer Module Supervisor Module Business Objects Introduction to Designing Universes Reporting Requirements The Designer Module Populating the Structure with Tables Joins Creating and testing Classes & Objects Creating and testing Measure Objects Resolving loops In a Universe Business objects with webintelligence 6.5 Introduction to Webintelligence 6.5 Getting Started with Infoview Viewing Documents in Infoview Creating New Documents with Queries Restriction Data Returned by a Query Displaying Information in different Ways Enhancing Report Presentation Formatting Reports Creating Formulae and Variables Analyzing Data at a Deeper Level Sharing Documents Architecture Designer CMS Desktop Intelligence Web Intelligence Cognos ReportNet with Cognso 8 Architecture Framework Manager Metadata Modelling Package Development Package Import & Export Query Studio Report Studio -Basics Report Studio -Advanced DataStage 7.X 1.DataStage Administrator Server Properties DataStage Project Administration Adding Projects Deleting Projects Cleaning up Project files NLS Configuration Project Export Option Project Import Option DataStage Director Introduction to DataStage Director DataStage Director Window Jobs Status View DataStage Director Options Limits Page View Page Priority Page Running DataStage Jobs Validating a Job Running a Job Stopping a Job Resetting a Job Job Scheduling Deleting a Job Job Batches Introduction to Job Batch Creating a Job Batch Running a Job Batch Scheduling a Job Batch Unscheduling a Job Batch Monitoring Jobs The Monitor Window Showing Unks Showing (])U Usage Stage Status Window DataStage Designer Importing Table Definitions Importing Flat Ale Definitions Designing Server Jobs Aggregator Stage Transformation Stage Annotations Annotations Descriptions Shared Containers Local Containers Reject Rows Implementing RouterStage Data Elements Routines Developing Custom Routines Job Sequencer Implementing Simple & Complex Jobs DataStage Manager Introduction to DataStage Manager Importing Table Definitions Importing Flat File Definitions Managing the Meta Data Environment