best informatica training centre in Chennai adyar

21/06/2012 Computer - Multimedia Classes

Price: Check with seller


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

Data Warehousing

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


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)


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


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.


Greens Technologys,
No.15 First Street,Padmanabhanagar,

Best Regard’s

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

More Details

Total Views:12
Reference Id:#75713
Phone Number:919840496320
Website URL:Click To Visit
Current Rating: /5 0 Vote


Copyright © 2020 |   All Rights Reserved | |   24x7 support |   Email us : info[at]