DATA WAREHOUSING CONCEPTS:

 

Ø  Data Warehouse

Ø  Data Mart

Ø  OLAP VS OLTP

Ø  Data Warehouse Architecture

Ø  Dimensional Modelling

Ø  Star Schema

Ø  Snowflake Schema

Ø  Fact & Dimensions

Ø  Types of Facts and Types of Dimensions

Ø  Change Data capture

 

INFORMATICA POWER CENTER 9

 

1. POWER CENTER COMPONENTS 

 

Ø  Repository Manager 

Ø  Designer 

Ø  Workflow Manager 

Ø  Workflow Monitor 

 

2. INFORMATICA CONCEPTS AND OVERVIEW AND ARCHITECTURE

 

DESIGNER COMPONENTS

Ø  Source Qualifier 

Ø  Target Designer 

Ø  Transformation developer

Ø  Mapplet designer

Ø  Mapping designer

WORKFLOW MANAGER COMPONENTS

Ø  Task Developer

Ø  Worklet Designer

Ø  Workflow Designer

 

3. SOURCES 

 

Ø  Working with relational Sources 

Ø  Working with Flat Files

 

4. TARGETS 

 

Ø  Working with Relational Targets 

Ø  Working with Flat file Targets

 

5. TRANSFORMATIONS

Ø  Filter Transformation

Ø  Router Transformation

Ø  Sorter Transformation

Ø  Union Transformation

Ø  Joiner Transformation

Ø  Source Qualifier Transformation

Ø  Expression Transformation

Ø  Aggregator Transformation

Ø  Rank Transformation

Ø  Sequence Generator Transformation

Ø  Normalizer Transformation

Ø  Stored Procedure Transformation

Ø  Transaction Control Transformation

Ø  Update Strategy Transformation

Ø  XML Source Qualifier Transformation

Ø  Lookup Transformation

Ø  Mapplet Input

Ø  Mapplet Output

6. POWER CENTER SUPPORTED FUNCTIONS(OPTIONAL)

Ø  Numeric functions

Ø  String Functions

Ø  Date Functions

Ø  Conversion Functions

Ø  Cleansing Functions

Ø  Aggregate Functions

LEVEL 2  ADVANCED LEVEL

  

Ø  Versioning (Check out,Check in)

Ø  Shared Folders

Ø  Short Cuts

Ø  User Defined Functions

Ø  Scheduling Informatica Jobs

 
CONTACT ME
CONTACT ME
close-link
Hi how can I help you
Scroll to Top