Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    Informatica - Datawarehousing: Duration: 50 Hours Prerequisites Course Contents 1. RDBMS Concepts

    Uploaded by

    vishal lalwani
    This document provides an overview of the course contents for a 50-hour Informatica - Datawarehousing training program. The course covers topics such as RDBMS concepts, data warehousing concepts, ER modeling, SQL, PL/SQL, the Informatica tool including transformations, workflows, repository management, and real-time data warehousing project scenarios. Hands-on exercises are included using tools like ERWIN, Informatica Designer, Workflow Manager, and the Workflow Monitor. The goal is to teach students how to design, develop and implement real-time data warehousing solutions using Informatica.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Informatica - Datawarehousing: Duration: 50 Hours Prerequisites Course Contents 1. RDBMS Concepts

    Uploaded by

    vishal lalwani
    25 views2 pages
    This document provides an overview of the course contents for a 50-hour Informatica - Datawarehousing training program. The course covers topics such as RDBMS concepts, data warehousing concepts, ER modeling, SQL, PL/SQL, the Informatica tool including transformations, workflows, repository management, and real-time data warehousing project scenarios. Hands-on exercises are included using tools like ERWIN, Informatica Designer, Workflow Manager, and the Workflow Monitor. The goal is to teach students how to design, develop and implement real-time data warehousing solutions using Informatica.

    Original Description:

    dar

    Original Title

    37_Informatica_3RITech

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of the course contents for a 50-hour Informatica - Datawarehousing training program. The course covers topics such as RDBMS concepts, data warehousing concepts, ER modeling, SQL, PL/SQL, the Informatica tool including transformations, workflows, repository management, and real-time data warehousing project scenarios. Hands-on exercises are included using tools like ERWIN, Informatica Designer, Workflow Manager, and the Workflow Monitor. The goal is to teach students how to design, develop and implement real-time data warehousing solutions using Informatica.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    25 views2 pages

    Informatica - Datawarehousing: Duration: 50 Hours Prerequisites Course Contents 1. RDBMS Concepts

    Uploaded by

    vishal lalwani
    This document provides an overview of the course contents for a 50-hour Informatica - Datawarehousing training program. The course covers topics such as RDBMS concepts, data warehousing concepts, ER modeling, SQL, PL/SQL, the Informatica tool including transformations, workflows, repository management, and real-time data warehousing project scenarios. Hands-on exercises are included using tools like ERWIN, Informatica Designer, Workflow Manager, and the Workflow Monitor. The goal is to teach students how to design, develop and implement real-time data warehousing solutions using Informatica.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    http://www.3ritechnologies.

    com Call us: 02065003366


    8308103366

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

    You might also like