Informatica

What is Data warehouse
Components of Data warehouse
Decision support systems
OLTP Systems
OLTP vs DATA WAREHOUSE
ODS(operational data store)
Difference between ODS and DATA WAREHOUSE
Data Mart
Difference between Data warehouse and Data Mart
Difference between Data warehouse and ODS,OLTP
Data warehousing for OLTP systems
Data cleansing
Independent Data warehouse
Dependent Data warehouse
Meta data and Data Mining
OLAP,ROLAP,MOLA< /li>

DATABASE DESIGN AND DATA MODELING

ER Model for transactional processing
Introduction to Data Modeling
Entities and Attributes
What is the use of data modeling in Data warehousing
Schema
Star Schema
Snowflake Schema
Snowflake Schema(hybrid schema or galaxy schema)
Fact table
Dimension tables
Multi dimension tables
Grain warehousing tools consideration
Granularity for the data warehousing

INFORMATICA 8.6

Introduction of Informatica (power mart and power centre)
Difference between power mart and power centre
ETL Architecture
Difference between 7 and 8 Versions
Data source
Data targets
Repository
Meta data
Server components
Client components

INFORMATICA REPOSITORY SERVER

Administrator password
Port number

INFORMATICA SERVER ADMINISTRATOR CONSOLE(RSAC)

Creating Informatica Repository Server(IRS)
Connecting the server
Creating repository
Repository considerations

INFORMATICA REPOSITORY MANAGER

Creating the workspace(folder)
Creating the users
Changing the user passwords
Creating users groups
Giving privileges to the users, user groups and folder

INFORMATICA DESIGNER

Connecting to the designer
Components of the designer
Creating DSN(data source name)
Source, Database
Accessing the source, definitions to the designer
Warehouse Designer
Creating the target tables using warehouse designer
Generating target table to database
Mapping designer
Mapping between the source and target tables
Transformations between source and target tables

TYPES OF TRANSFORMATIONS

Source qualifier
Aggregator
Filter
Expression
Stored procedure
Lookup
Sorter
Joiner
Router
Xml source qualifier
Update strategy
Normalizer
Ranking
Sequencer generator
Transaction control
Union
Custom

Slowly changing dimensions (scd) Mapplets
Cubes and dimensions (creating star schema)
Reusable transformations Debugger
Working with mapping using debugger
Data Profiling
Variable and Parameters
New features in power centre 8.1
WORKFLOW MANAGER
Components of workflow manager
Types of tasks

Session
E-mail
Command

Creating workflow
Scheduling the workflow
Creating connections
Assigning connection values to the sessions
Creating server (informatica server)
Assigning server to workflow
Workflow monitor
Session logs
Workflow logs
Performance Tuning
Database Performance
Creating Indexes, Explain Plan, Hints.
Informatica performance
Deployment
Types of Code Deployment
Advantages of Deployment

Database : Oracle or SQL Server

Shopping Cart Software