=============PARTHIBAN N=====9840496320====

Data Warehousing

Course Content for Inf 8.1, B O XI R2 &Cognos 8

Introduction:

Basic Concept of Datawarehousing

Datawarehousing Architecture

Data modeling Concepts

Physical Data Modeling and Logical Data Modeling

Star Schema and Snow Flake Schema

ETL Process Flow

Reporting Process Flow

Informatica 8.1

Extraction, Transformation and Loading (ETL)

Administration

Configuring the Repository Server

Starting the Repository Server

Configuring Informatica Server

Process involved in creating Repository in Administrator Console and starting the repository.

Taking Backup and restoring the repository.

Working with Repository Manager.

Creating folders, users, groups, granting privileges etc.

Working with Designer

Process involved in Extraction transformation and loading of tables.

Importing and Exporting Source and Target Metadata.

Creating Target Tables with constraints

Involved in creating of simple mapping and complex.

Types of Transformation

Expression Transformation

Aggregator Transformation

FilterTransformation

Router Transformation

Joiner Transformation

Source Qualifier Transformation

Lookup Transformation

Update strategy Transformation

XML Source Qualifier Transformation

Sorter Transformation

Ranker Transformation

Custom Transformation

Union Transformation

Transaction control Transformation

Process involved in Extraction of data from Flat file to Database and vice versa.

Process involved in Extraction of data from XML file to Database.

Creating Reusable Transformation in Transformation Developer

Creating Reusable Objects in Mapplets Designer.

Involved in Exporting and Importing Mapping and metadata.

Cube and Dimensions

Involved in Creating Dimension

Involved in Creating Cubes.

Creating complex mapping for Cubes and dimension.

Creating workflow for the cubes and dimension mapping.

Testing the workflow.

Slowly Changing Dimension

Type 1: Involved in the creation of mapping and testing the output

Type 2: Involved in the creation of mapping and testing the output

Type 3: Involved in the creation of mapping and testing the output

Working with Workflow Manager

Involved in creation of Tasks Such as Session, Command and Email.

Working with Task Developer.

Involved in creation of simple and comples workflow.

Involved in creation of Batch Session.

Running the workflow.

Configuring the web brower and Assigning web server.

Involved in creation of scheduler and configuring the scheduler.

Working with Workflow Monitor

.

Monitoring the session and workflow.

Troubleshooting the errors.

Checking log property.

Checking the output with session log.

Checking the Performance statistics.

Contact

Greens Technologys,
No.15 First Street,Padmanabhanagar,
Adyar,
Chennai-20.

Best Regard’s

N.PARTHIBAN
Phone(M): +91 98404 96320
Phone(L): 044 43511623

eMail:greens.adyar@yahoo.com

Contact seller Print Share

Location Map

Comments

Leave your comment (spam and offensive messages will be removed)

Your name:
Your e-mail:
Title:
Comment:
Send

Contact publisher

Name: Greens

Your name: Your e-mail address: Phone number (optional): Message:

Enter the words above:

Help

Send

Useful information

• Avoid scams by acting locally or paying with PayPal
• Never pay with Western Union, Moneygram or other anonymous payment services
• Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
• This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"