SAINORA

HomeCourses Data Warehousing

Data Warehousing

Data warehousing Concepts

  • What is Data warehousing?
  • Characteristics of Data warehouse
  • 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 Monitor
    • Workflow Log
    • Session Log
    • Types of View
  • Designer
    • Source Analyzer
    • Target Designer
    • Mapping Designer

Transformation

  • Transformation Basics
    • Classification
    • Types of ports
    • Data Types
  • 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

Workflow

  • 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
  • File Repository Concepts
    • Indirect loading
  • Types of Scheduling
    • Time-based schedule
    • Event-based schedule
  • Mapping Migration Process
    • Copy from Folder
    • Import and Export