Start Learning DataWarehousing

Hi Friend
I am a Data Warehousing developer. I have some basic knowledge in Data warehousing and ETL and Reporting tools. In my blog i decide to share that knowledge with other. I think sure it will be use for readers. If u have any doubts mail me sundar.skec@gmail.com. friends learn the content in date wise then it will be easy to understand.

Introduction to Data Warehousing:

• Data Warehousing Concept
• Difference between Transactional and Warehoused Data
• Data Warehousing Architecture
• Logical & Physical Design
• Difference between Data Warehouse & Data Mart
• Source Data ,Staging Area & Target Data
• Operational Data Source (ODS)
• Star Schema & Snow Flake Schema

Data Warehouse Design and Modeling:

Dimension Model (Schema) for Data Warehouse

• Defining Dimensions And Measures
• Defining Levers and Hierarchies
• Granularity of data
• Introducing Star Schema
• Introducing Snow Flake Schema
• Dimension Table And Fact Table

ETL (Extract, Transform & Load) Using Informatica:

• Designer : Defining Target for Staging data base & Data Warehouse
• Designer : Creating Multi-dimensional Cubes
• Designer : Creating Mapping (with different transformation) and Mapplets
• Transformation
1. Filter
2. Router
3. Sorter
4. Rank
5. Aggregator
6. Expression
7. update staterge
8. Lookup
9. Normalizer
10. stored Procedure
11. source qualifier
• Task
1. Session
2. command
3. Email
4. Event Wait
5. Event Raise
6. Timer
7. Assignment
8. Control
• Server Manager : Creating Sessions and batches
• Concepts Workflow monitor

OLAP & PRESENTION using COGNOS:

• Impromptu Administration : Defining database and setting up catalog
• Impromptu Administration : Creating and Managing Folders, Prompts, Filter, Formula
• Impromptu Administration : Defining Classes, Users & Privileges
• Impromptu Administration : Generating & Formulating Falt Reports
• Impromptu Administration : Generating Query Definition File
• Cognos Powerplay Transformer : Creating Dimensions and Measures
• Cognos Powerplay Transformer : Generating Cubes, Manipulating Cube Properties
• Cognos Powerplay Transformer : Generating Multi-Dimensional reports using cube
• Cognos Powerplay Transformer : Formatting & Printing Reports
• Cognos Powerplay Transformer : Drill-down, Drill-up and Drill-through Reports
• Cognos Powerplay Transformer : Generating Chats using cube

OLAP & PRESENTATION using BUSINESS OBJECTS

• Supervisor: Creating Repository and Supervisor
• Supervisor: Database Connections
• Supervisor: Defining Groups and Users
• Supervisor: Defining Privileges and Profiles for users
• Supervisor: Scheduling Users Connection Sessions
• Designer: Creating and Maintaining Universe
• Designer: Defining Tables & Columns as Classes and Objects
• Designer: Creating and Maintaining measures
• Designer: Defining Relations, Formulas etc
• Business Object: Defining Query, Reports Type
• Business Object: Formatting Reports
• Business Object: Slicing & Dicing Reports
• Business Object: Drill-down, Drill-up Reports
• Business Object: Filtering Records, Grouping Records etc.