Follow us on

DWH Concept

  • Introduction and Definition
  • Sources, Transformations and Targets (Architecture)
  • Data Extraction, Data Transformations and Data Loading (Data Acquisition Process)
  • Data Warehousing Approaches
  • Staging Area, Metadata, Repository and Data Mart
  • Data Modeling
  • Differences between OLTP and OLAP (DSS) Systems
  • Operational Data Store (ODS)
  • Business Intelligence
  • Star Schema Design & Snow-Flake Scheme
  • Junk Dimension Confirmed Dimension, Fact less Fact Table, Types of Facts
  • Slowly Changing Dimensions (SCD)

Informatica Concept

  • Introduction to INFORMATICA
  • ETL process in Informatica
  • ETL naming conventions of different vendors
  • Informatica Products (Power Center and Powermart)
  • Informatica Softwares (Server and Client)
  • Informatica Components and sub-components (Server and Client)
  • ETL Implementation Tasks in Informatica
  • Informatica Architecture

Informatica Transformations

  • Source Qualifier
  • Filter
  • Expression
  • Sorter
  • Aggregator
  • Sequence Generator
  • Rank
  • Router
  • Union
  • Joiner
  • Lookup
  • Stored Procedure
  • Update Strategy
  • Java
  • Transaction Control Transformation
  • Normalizer
  • XML Source Qualifier

Informatica Advanced Concepts

  • Implementing Constraint Based Load Ordering
  • Implementing Target Load Plan
  • Creating and Implementing Unconnected Lookup
  • Creating and Implementing Unconnected Stored Procedure
  • Debugging Mapping (Before creation of session and After creation Session)
  • Creating and Implementing Reusable Transformation
  • Creating and Implementing Mapplet
  • Defining and Using Mapping Parameter
  • Defining and Using Mapping Variable
  • Reusable and Non-Reusable Sessions
  • Implementing Pre SQL and Post SQL
  • Active and Passive Transformations
  • Executing workflow by using pmcmd command
  • Scheduling workflow
  • SQL Override (SQ as Filter and SQ as a Joiner )
  • Creating and using User Defined Function (UDF)
  • Slowly Changing Dimensions by wizards( SCD-TYPE1, SCD-TYPE2, SCD-TYPE3 )
  • Creating and Implementing Worklet
  • Data Extraction from Flatfiles (Fixed width and Delimited)
  • Data Extraction from Indirect Files (File Repository)
  • Exporting and Importing Mappings
  • Creating and Using E-mail task
  • Creating and Implementing DYNAMIC LOOKUP
  • Note: Manual Implementation of Slowly Changing Dimensions( SCD-TYPE1, SCD-TYPE2, SCD-TYPE3 )

NOTE: After completion of course

  • 10 Assignments
  • FAQs Review
  • Project Explanation

Follow us on