Demos On 16th / 17th December
PIMPLE SAUDAGAR :    Hadoop BigData (09:00 AM)   |   AWS - Amazon Web Services (11:00 AM)   |   Selenium (11:00 AM)   |   Angular JS (11:00 AM)   |   Informatica (11:00 AM)   |   QTP (2:00 PM)      DECCAN :    Selenium (10:00 AM)   |   AWS - Amazon Web Services (1:00 PM)   |   DevOps (2:00 PM)   |   Manual Testing (2:00 PM)   |   UNIX Shell Scripting (2:00 PM)   |   SAP MM (3:00 PM)      
ISO 9001:2015 Certified Organization  |  Pearson Exam Center

Informatica - Datawarehousing

Overview

A data warehouse is constructed by integrating data from multiple heterogeneous sources. It supports analytical reporting, structured and/or ad hoc queries and decision making. This tutorial adopts a step-by-step approach to explain all the necessary concepts of data warehousing.

Duration : (50 hours)

Prerequisites : No specific Knowledge Required.

Training Highlights : All our trainers’ expertises on both development and training which helps us deliver project based training. All our trainings focuses on practical than theory model.

Course Syllabus

Informatica - Datawarehousing
  1. RDBMS Concepts
    • What is RDBMS?
    • Evolution of the Database Model
    • Entity Relationship Model
    • Normalization
    • Integrity Rules
    • ER Diagrams
    • ER Model
  2. Data Warehousing Concepts
    • What is Datawarehouse ?
    • Need For Datawarehouse
    • Data Warehouse Properties
    • Data Warehouse and Data Mart
    • OLTP and OLAP
    • Data Warehouse Lifecycle
    • Data Warehouse Testing Lifecycle
    • Dimension Modeling
    • Dimensions and Facts
    • Types of Dimensions (Conformed, Junk, Degenerate, Role Playing, Slowly Changing Dimensions(1,2,3) etc
    • Types of Facts (Additive, Semi Additive, Non Additive)
    • Levels and Hierarchy
    • Star Schema/Snowflake Schema/Fact Constellation Schema
    • ROLAP/MOLAP/HOLAP
    • Slowly changing Dimensions (SCD Type 1,2,3)
    • Cubes and its Functions
  3. ERWIN (Data Modeling Tool)
    • Forward Engineering
    • Reverse Engineering
    • Update Model, Alter database
    • Complete Compare
  4. Basic SQL/PLSQL
    • Oracle Pre Defined Data types
    • DDL Commands( Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop)Columns, Rename, truncate, drop
    • DML- Insert, update, delete
    • DQL-SELECT Statements using WHERE clause
    • Comparison and Conditional Operators
    • Arithmetic and Logical Operators
    • Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
    • Introduction to Pl/SQL
    • Cursors(Implicit and Explicit)
    • Stored Procedures
    • Functions
    • Triggers
    • Exceptions
  5. INFORMATICA
    • Introduction to ETL
    • Introduction to Informatica
    • Naming Conventions
    • Repository Module
    • Understanding Repository
    • Creating Folders and Granting Object Permissions
    • Labels
    • Copying Folders
    • Designer Module
    • Working with Sources
    • Working with Flat Files
    • Working with Targets
    • Data Transformation Source and Target
    • Mapping Parameters and Variables
    • Using the Debugger
    • Creating Cubes and Dimensions
    • Using the Mapping Wizards
    • Working with Transformations
    • Aggregator Transformation
    • Expression Transformation
    • Filter Transformation
    • Router Transformation
    • Normalizer Transformation
    • Rank Transformation
    • Transformation Module
    • SQL Transformation
    • Union Transformation
    • Update Strategy Transformation
    • Source Qualifier Transformation
    • Stored Procedure Transformation
    • Lookup Transformation
    • Joiner Transformation
    • Transaction Control Transformation
    • Sorter Transformation
    • Sequence Generator Transformation
    • Workflow Module
    • Workflow Manager Overview
    • Workflow Designer
    • Task Developer
    • Worklet Designer
    • Using Workflow Wizard
    • Creating a Task
    • Configuring Task
    • Creating different types of tasks (Session ,Command ,Assignment Decision ,Timer)
    • Working with Worklets
    • Workflow links
    • Connection Objects Overview
    • Validating Tasks ,Workflows and Worklets
    • Scheduling and Running Workflows
    • Using the Debugger
    • Workflow Monitor
    • Workflow Monitor Overview
    • Using Workflow Monitor
    • Customize Workflow Monitor
    • Working with Tasks and Workflows
    • Workflow and Task Status
    • Using Gantt Chart and Task Views
    • Session and Workflow Logs
    • Workflow Monitor Details
    • Command Reference
    • Using Command Line Programs
    • infacmd
    • infasetup
    • pmcmd
    • pmrep
    • Real Time Datawarehouse Project Scenarios
    • Interview Questions

Inquire Now



Student’s Reviews about 3RI