X
I agree to the terms and privacy policy
144188195215245280

Veesion Knowledge Systems

Pune, Maharashtra
View Mobile Number

Software Training Services

Our organization is indulged in offering Software Training Services to our clients. We have been successful in catering to the requirements of our esteem clients by offering quality Software Training Services.

Data Warehousing Training
Interested in this product?
Request a Call Back
Our organization is offering Data Warehousing Training to our clients. We provide the highest quality and most practical education consistent with our instructors’ books and extensive experience in the dimensional approach. You’ll learn from the best in the business.

Data Warehousing Course Content
:

RDBMS

  • Understanding the terminology
  • What is database
  • RDBMS
  • Primary Key, Foreign Key, Index, Entity, Attributes
  • RulesER Modeling
  • Relationships
  • Logical Model
  • Physical ModelSQL
  • What is SQL
  • Data types
  • Basic SELECT statement
  • DML statements
  • DDL statements
  • Transaction Control statements
  • DCL statements Database Objects
  • Tables
  • Views
  • Constraints (PK, Index, FK, Not Null etc.) Using Operators and Function Group Functions
  • Logical, Boolean, Arithmetic Operators
  • Understanding the ‘Null’
  • PL/SQL
  • What Is PL/SQL
  • Difference between SQL and PL/SQL
  • Benefits of PL/SQL
  • Using SQL in PL/SQL Components of PL/SQL
  • Variables and Parameters
  • Control Structures (Ifthenelse, etc…)
  • Blocks
  • Cursors
  • Procedure
  • Functions
  • Triggers
  • Data Warehousing Concepts
  • Terminology
  • Explore : Data >> Information >> Knowledge
  • History and Need/Application of DWH
  • Understanding the definition of Data Warehousing
  • Exploring DWH term above its Definition DWH Architecture
  • Elements of DWH
  • DWH approach (Top Down, Bottom Up)
  • DWH Layers (Source Layer, Extraction Layer, Staging Layer, etc…)
  • DWH Vs Data Mart
  • OLTP Vs OLAP Dimension Modeling
  • Understanding terms: Measures, Surrogate Key, Dimensions, Facts, Hierarchy Levels, Cube
  • Types of Measures
  • Types of Fact Tables (Aggregate, Fact less, etc...)
  • Types of Dimension (Conformed, Degenerated, Junk, etc…)
  • Types of SCDs
  • Characteristics of SCD Type1, Type2, Type3
  • Types of Schemas (Star, Snowflake, etc...)
  • OLAP/MOLAP
  • ETL
  • Terminology
  • What is ETL
  • Need of ETL
  • What are ETL tools
  • Role of ETL in DWHETL Architecture
  • Source Extraction
  • Data Transformation Logic
  • Data Loading Transformation Operations
  • Understanding basic operation of Transformation Logic
  • Data Type Conversion Operation
  • Filtering operation
  • Sorting operation
  • Routing operation
  • Ranking operation
  • Calculation operation
  • Sequence Generation operation
  • Lookup operation, etc
 
UNIX:

  • Terminology
  • Basics of Unix
  • Basic Commands
  • Shell Scripting
  • Role of Unix in ETL
  • Working with commands for additional Tasks

 

Introduction To DWH Project Management Life Cycle:

  • Project Assumptions
  • Project Management Constraints Scope Schedule Effort
  • Escalation and Communication Stake Holders Roles
  • DWH Project Flow Business Requirement Gathering High Level Design Low level Design Mapping Design Review Testing Phase UAT Production ( GoLive )
  • After Implementation

 

Interpersonal:

  • Resume Preparation Key points Get noticed
  • Interview Preparation Communication Presence
  • Soft Skills Know Soft Skills Get align with industry demands

Download Attached PDF Below

View Complete Details

Get Best Quote

ETL - Informatica Training Services
Interested in this product?
Request a Call Back
    Our organization is indulged in offering ETL - Informatica Training Services to our clients. In this course, you will learn the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects, exposing core features of PowerCenter, through lecture and hands-on exercises.

    Features:

    • ETL
    • Terminology
    • What is ETL
    • Need of ETL
    • What are ETL tools
    • Role of ETL in DWH
    • ETL Architecture
    • Source Extraction
    • Data Transformation Logic
    • Data Loading
    • Transformation Operations
    • Understanding basic operation of Transformation Logic
    • Data Type Conversion Operation
    • Filtering operation
    • Sorting operation
    • Routing operation
    • Ranking operation
    • Calculation operation
    • Sequence Generation operation
    • Lookup operation, etc.
    • Informatica Power Center An ETL Tool
    • Introduction
    • Product Features
    • Applications Architecture
    • Server Components
    • Repository Server
    • Informatica Server
    • Client Tools Repository Manager Designer Work flow Manager Work flow Monitor
    • Connectivity of Components
    • Getting Started
    • Start the Services
    • Administration Console

     

      Understanding Services:

      • Repository Service, Integration Service
      • Configuring and Running of Services
      • Login, Connecting, Managing Folders
      • Designer
      • Components of Designer tool Source Analyzer Target Designer Mapping Designer Transformation developer
      • Mapplet Designer
      • Working with Database Sources
      • Working with Flat Files
      • Working with Targets
      • Mappings
      • Mapplets
      • Mapping Parameters and Variables
      • User Defined Functions
      • Debugger
      • Transformations
      • Creating a Transformation
      • Configuring a Transformation
      • Working with Ports
      • Working with Expressions
      • List of Transformations
      • Aggregator
      • Expression
      • Source qualifier
      • Rank
      • Filter
      • Router
      • Stored Procedure Connected Unconnected
      • Transaction control
      • Normalizer
      • Sequence generator
      • Union
      • Joiner
      • XML Source qualifier
      • Sorter
      • Look up Connected Unconnected
      • Update Strategy etc

      Repository Manager

      • Understanding Repository
      • Using Repository Manager
      • Managing Folders
      • Managing Repository Objects Work flow Basics
      • Workflow Manager Options Using Work space Working with Repository Objects
      • Workflows and Work lets Creating a Workflow Workflow Wizard Assigning an Integration Service Working with Worklets Working with Links
      • Sessions Editing a Session Commands
      • Tasks Creating Task Configuring Task Command Task
      • Control Task Control Task Event Task Timer Task
      • Sources Overview Configuring Sources in Sessions Working with Relational Sources Working with File Sources
      • Validation Validating Tasks Validating Workflows Validating Worklets Validating Sessions
      • Session and Workflow Logs Log Events Working with Log Files Workflow Logs Session Logs Command Reference
      • Using Command Line Programs Infacmd Infa setup Pmcmd Pmrep
      • Transformation Language Reference
      • The Transformation Language
      • Constants
      • Operators
      • Variables
      • Dates
      • Functions
      • Performance Tuning
      • What is Performance Tuning
      • Key Levels for Performance Tuning
      • Performance Tuning Overview
      • Scope for Performance at Mapping Level


      Download Attached PDF Below:

      View Complete Details

      Get Best Quote

      BI Training Services
      Interested in this product?
      Request a Call Back

      BI Training Services

      Get Latest Price

      We are a leader in offering a best quality of Business Intelligence Training Services to our clients. BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are reporting,online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining,predictive analytics and prescriptive analytics.

      View Complete Details

      Get Best Quote
      Tell us what you
      need
      Receive seller
      details
      Seal the deal
      Save time! Get Best Deal
      I agree to the terms and privacy policy