Course Content:
1. INTRODUCTION TO DATAWARE HOUSING
1.1 What is Dataware housing.
1.2
Need for Dataware housing
1.3
Components of Dataware house
1.4
Data Integration Concepts
1.5
Types of Systems OLTP DSS
1.6 Maintanence of Dataware house
1.7
DSS,DataMart,OLAP
1.8
Dataware housing Lifecycle
1.9
Dataware housing Testing Life cycle
2. DATABASE DESIGN AND DATA MODELING
2.1
Dimension
2.2
Fact
2.3 Types of Dimensions
2.4
Types of Facts
2.5
Star Schema
2.6
SnowFlake Schema
2.7
Factless Fact table
2.8
Confirmed Dimensions
2.9
Hierarchy
3. INFORMATICA 8.6 CONTENTS AND CONCEPTS
3.1
Introduction toInformatica 8.6
3.2
Informatica
Power Center
8.6 Architecture
3.3
Informatica Web Admin Console
3.4
Informatica Repository Manager
3.5
Designer-Power
Center Components and User
Interface
4. INFORMATICA POWER CENTER 8.6 COMPONENTS
4.1
Power Center Components
4.2
Power Center Designer
4.3 Repository Manager
4.4 Workflow Manager
4.5 Workflow Monitor
5. INFORMATICA
OBJECT DESIGNERS AND TYPES OF OBJECTS
5.1 .1
Informatica Source Designer
5.1.1.1
Working with relational sources
5.1.1.2
Working with Flat Files
5.1.2 Informatica Target Designer
5.1.2.1
Working with Relational Soources
5.1.2.2
Working with Flat Files
5.1.3
Transformations
5.1.3.1
Aggregator Transformation
5.1.3.2
Expression Transformation
5.1.3.3
Filter
Transformation
5.1.3.4
Joiner
Transformation
5.1.3.5
Lookup
Transformation
5.1.3.6
Normalizer
Transformation
5.1.3.7
Rank
Transformation
5.1.3.8
Router
Transformation
5.1.3.9
Sequence
Generator Transformation
5.1.3.10
Stored
Procedure Transformation
5.1.3.11
Sorter
Transformation
5.1.3.12
Update
Strategy Transformation
5.1.3.13
XML
Source Qualifier Transformation
5.1.3.14
Advanced
External Procedure Transformation
5.1.3.15
External
Transformation
5.1.4 Informatica
Mapping Desiner
5.1.4.1
Creating
Mappings
5.1.4.2
Validate
Mappings
5.1.4.3
Mapping
Variables & Parameters
5.1.5 Informatica Sessions
5.1.5.1
Create
Sessions
5.1.5.2
Types
of Sessions
5.1.6
Tasks
5.1.6.1
Defining
Tasks
(1) Command Tasks
(2) Email Tasks
(3) Session Tasks
(4) Link Condition
(5) Event Wait & Event Raise
6. Workflow
Manager
6.1
Creating Workflow
6.2
Starting Workflow
6.3
Monitoring Workflow
7. Workflow
Monitor
7.1 Workflow and Task Status
7.2 Sessions and Workflow Logs
8. Informatica
Advanced Features
8.1
Incremental Aggregation
8.2 Mapplet Implememtation
8.3 Target Load Plan
8.4 Constraint Based Loading
8.5 Mapping Parameters
8.6 Mapping Variables
8.7 Session Parameters
8.8 Reusable Transformation
8.9 Tasks and Types of Tasks
8.10 Scheduling Workflow
8.11 Control flow using command task and event
wait task
8.12 Perform Testing ETL
8.13 Unit Testing ETL
8.14 System Testing ETL
8.15 Incremental loading
|
