Data Warehousing Training in Chennai

Software Testing Training in Chennai

Data Warehousing Training in Chennai

Sakthi Software Solutions offers Best Data warehousing Training in Chennai. A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.

Course Content:


Data warehousing Concepts:

  • What is Datawarehousing?
  • Characteristics of Datawarehouse
  • Difference between OLTP and DWH
  • Architecture of DWH
  • Various BI Tools
  • Types of DWH
  • Data Modeling Types
  • Types of Dimensional Data Modeling
  • Surrogate key
  • Types of Dimension

Power Center Components:

  • Introduction to ETL
  • Informatica Architecture

Power Center Client Tools:


Repository Manager

  • Manager Folders

Designer

  • Source Analyzer
  • Target Designer
  • Mapping Designer

Workflow Manager

  • Task Developer

Workflow Designer

 

Workflow Monitor

  • Workflow Log
  • Session Log
  • Types of View

Transformation Basics

  • Classification
  • Types of ports
  • Data Types

Types of Transformations

 

Source Qualifier Transformation

  • Creating Simple Pass through Mapping
  • Apply Various Filter Conditions
  • Specify sorted ports
  • Eliminate Duplicate Values
  • Creating Custom SQL Query
  • Joining two or more tables

Source Qualifier Transformation

  • Compare with Source Filter
  • Types of Tracing Level
  • Types of Flat files
  • File Import Wizard
  • Load data from Flat File to Database
  • Load data from Database to Flat File

Sorter Transformation

  • Types of Ports
  • Multiple Sorting
  • Case Sensitive Sorting
  • Null Handling

Joiner Transformation

  • Joining two heterogeneous sources
  • Master Source
  • Join Condition
  • Types of Joins
  • Sorted input option

Rank Transformation

  • Types of Ports
  • Rank Index
  • Rank and Dense rank

Sequence Generator

  • Use of Sequence Generator
  • Output Ports
  • Cycle Option
  • Usage of Reset

Expression Transformation

  • Use of Expression Transformation
  • Apply Arithmetic Operators
  • Data Cleansing Functions
  • Usage of Variable Port
  • IIF and Decode functions

Aggregator Transformation

  • Informatica aggregate functions
  • Sorted input options

Router Transformation

  • Types of Groups
  • Group Conditions
  • Union Transformation
  • Types of Groups

Normalizer Transformation

  • Types of Normalizer
  • Transpose Columns to Rows
  • Creating Normalizer Ports
  • Default Output Ports

Lookup Transformation

  • Connected Vs Unconnected Lookups
  • Join Condition
  • Types of Ports
  • Unconnected Procedure
  • Lookup Caches

Stored Procedure Transformation

  • Create a Sample Procedure
  • DBA Script

Update Strategy Transformation

  • Database Operations
  • Data Driven
  • Forward Rejected Rows

Slowly Changing Dimensions (SCD)

  • Type 1
  • Type 2
  • Type 3

Transformation Developer

  • Create a Reusable Transformation
  • Promoting Transformations

Mapplet Designer

  • Create a reusable Mappings

Mapping Parameters

  • Design Parameter File

Mapping Variables

  • Set Variables function

Session Variables

  • Setting Connection

Workflow Variables

 

File Repository Concepts

  • Indirect loading

Target Load Plan


Types of Scheduling

  • Time-based schedule
  • Event-based schedule

Mapping Migration Process

  • Copy from Folder
  • Import and Export

(c) 2013 Sakthi Software Solutions Pvt.Ltd. All Rights Reserved