This course introduces students to ETL tool used to extract , transform and load data from source rdbms oracle database current data into target warehouse any rdbms history data. Participants explore the difference between oltp and olap databases. They also examine how to automate the ETL projects so that no need end user to interact with any databases for history data maintainance. So that this history data is useful for generating formatted outputs and used for analysis purpose using any reporting and analysis tools.

Course Duration : 45 Hours

Prerequisites | Required

  •    Knowledge on any RDBMS

Prerequisites | Suggested

  •    Previous any Programming knowledge

   DW Fundamentals
   DW architecture
  Difference between OLTP and OLAP
  Tables in DW
  Types of schemas
  Types of DW approaches
  Informatica Definitions
  Informatica Architecture
  Types of Transformations
  Slowly changing dimension type1
  Slowly changing dimension type2
  Slowly changing dimension type3
  Types of batch processing
   Types of workflow tasks
  Mapping parameters
  Mapping variables
  Session variable
  File List
  Dynamic connection


Hands On Exercises

Course Completion Certificate

Live Project

Certification Exam

Suggested Next Courses


  •   Reporting tools - Cognos, Tableau.