Course in Informatica - Data Warehousing

Course

In Chennai

Price on request

Description

  • Type

    Course

  • Location

    Chennai

Facilities

Location

Start date

Chennai (Tamil Nādu)
See map
No. 1, Dr. Singaravelu Street, Pondy Bazaar, T Nagar, (near Krishna Sweets), 600040

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Content:

Database Run through:

* Working with oracle
* DDL, DML, DTL statements
* Writing Basic SQL SELECT Statements
* Eliminating Duplicate Rows
* Restricting and Sorting Data
* Clause- where, group by order by
* Constrains- primary, not null, unique, check
* Single-Row Functions
* Joins: inner join, outer join, self join, natural join
* Indexes

Introduction to Data Warehousing:

* Data Warehouse Concept
* Differences between Transactional and Warehoused Data
* Data Warehouse Architecture
* Logical & Physical Design
* Difference between Data Warehouse & Data Mart
* Source Data, Staging Data & Target Data
* Operational Data Sources (ODS)
* OLA, ROLAP & MOLAP
* Star Schema, Star FLAKE Schema & Snow Flake Schema
* Normalization and De-normalization
* Meta Data & Data Mining

Database Design and Modeling:

* Entity-Relation Model(E-R Model) for Transactional Database

* Defining Entities and their Relationship
* Distribution of Attributes under Entities
* Normalization of Entities
* Modeling Logical E-R Model using Erwin Tool
* Conversion of Logical Model into Physical Model
* Application of Business Rules
* Constraints, Triggers, Domains, Back-end Programs, etc.

* Dimensional Model (Star Schema) for Data Warehouse

* Defining Dimensions and Measures
* Defining Levers and Hierarchies
* Granularity of Data
* Introducing Star Flake Schema
* Introducing Snow Flake Schema
* Dimension Table and Fact Tables
* Fact less Fact Table
* Additive, Semi-additive and Non-additive facts
* Many-To-One-To-Many Traps

INFORMATICA:

ETL (Extract, Transform & Load) Processes Using Informatica:

* ETL Basics
* Informatica Repository server configuration.
* Informatica server configuration
* Repository administration: Repository Creation, deletion, Backup & Restore
* Repository administration : Multiple Repository, Multiple Folders
* Repository Manager: Folder Creation, Deletion & Privileges Setup
* Repository Manager: User, Group & privileges Management
* Designer: Working with source analyzer, Defining Source from RDBMS, Semi-RDBMS, Flat file, XML File, Cobol File
* Designer: importing source and target meta datas
* Designer: Defining Target for staging database & for Data Warehouse
* Designer: Creating Cubes and dimensions
* Designer: Transformation Developer for Reusable User-defined transformation
* Designer: Mapplets for Reusable User-defined Mappings
* Designer: Mappings to apply Transformation Rules using 14 transformations
* Designer: Global referencing of objects across Folders & repositories
* Designer: Data Staging
* Work Flow Manager : Setting Up Server for repository
* Work Flow Manager: Creating Sessions and Batches
* Work Flow Manager: Scheduling Sessions and Batches
* Work Flow Monitor : Monitoring Sessions and Batches for Data Loading
* Work Flow Monitor : Troubleshooting Data Loading Errors
* Working with slowly changing dimension type1,type2,type3
* Working with slowly growing targets

Course in Informatica - Data Warehousing

Price on request