Informatica Administration And PowerCenter Topics

Informatica Administration

Topic Topics covered

Topic 1: Architecture of Power Center (Domain, Node and Services)
Installing Oracle (Pre requsit)
Create domain user and Repository Users & grant Privilages
Installing Informatica ( Server & client tools)

Topic 2: Creating the Repository Service
Creating and Deleting Repository Content
Enabling Version Control
Managing Repository User Connections and Locks
Backing Up and Restoring the Repository

Topic 3 : Creating an Integration Service
Enabling and Disabling the Integration Service
Configuring the Integration Service Properties
Configuring the Associated Repository
Configuring the Integration Service Processes

Topic 4: Managing the Domain
Starting and stopping Informatica services
Configuring Connectivity / Connecting to an Oracle Database (TNS Entry)
Administration Console
Viewing Domain Logs Repo Logs Integration service Logs

Topic 5: Users and User Accounts
Managing Users
Managing Permissions and Privileges
Monitoring User Activity

Topic 6: Using the Repository Manager
Connecting to Domains and Repositories
Viewing Object Dependencies
Validating Multiple Objects
Comparing Repository Objects
Truncating Workflow and Session Log Entries

Topic 7: Folders Overview
Managing Folder Properties
Comparing Folders

Topic 8: Managing Object Permissions
Assigning Permissions
Changing the Object Owner

Topic 9: Working with Versioned Objects
Working with Version Properties
Tracking Changes to Versioned Objects
Checking Out and Checking In Objects
Deleting and Recovering Objects
Purging Versions of Objects

Topic 10: Code Migration Process
Copy Paste
Folder to Folder Copy

Topic 11: Exporting and Importing Objects
Exporting Objects
Importing Objects

Topic 12: Deployment Groups
Create a Deployment Group
Creating Lable
Query Lable and associate objects to a deployment group
Copying the deployment group

Topic 13: Managing Connection Objects
Creating Relational Database Connections
Managing Connection Objects

Topic 14: Working with Workflow Manager
Assigning an Integration Service
Scheduling a Workflow
Validating a Workflow
Manually Starting a Workflow

Topic 15: Monitoring Workflows
Viewing Repository Service Details
Viewing Integration Service Properties
Viewing Repository Folder Details
Viewing Workflow Run Properties
Viewing Session Task Run Properties
Viewing Performance Details
Stopping or Aborting the Workflow
Session and Workflow Logs
Log Events
Working with Log Files
Workflow Logs
Session Logs

Topic 16: Best Practices and procedure of the admin Activities
Command Line referance

INFORMATICA POWERCENTER 9.1

DATAWARE HOUSING FUNDAMENTALS

1. What is Database?

2. What is Data Warehousing?

3. Difference between OLTP Database and DWH.

4. ETL FUNDAMENTALS.

i) Data Extraction

ii) Data Transformation

iii) Data Loading

5. What is ETL Client?

6. DataMart and Types of Data Marts.

7. DataWareHouse-Database Design.

i) Star Schema.

ii) Snow Flake Schema.

iii) Galaxy Schema.

8. OLAP and Types of OLAPs

9. DataWareHouse Architecture.

INFORMATICA POWERCENTER 9.1

1. Power Center Components.

• Power Center Clients
• Power Center Repository.
• Power Center Domain
• Integration service
• Repository Service
• Administration Console

2. Difference between Informatica 8.X and 9.X

3. Power Center Architecture

4. Integration Service Architecture

TRANSFORMATIONS

a). ACTIVE TRANSFORMATIONS.

·         Filter Transformation

·         Router Transformation

·         Aggregator Transformation

·         Joiner Transformation

·         Union Transformation

·         Sorter Transformation

·         Rank Transformation

·         Transaction Control Transformation

·         Update Strategy Transformation

·         Normalizer Transformation

·         Source Qualifier Transformation

·         SQL Transformation.

 b). PASSIVE TRANSFORMATION

EXPRESSION TRANSFORMATION
SEQUENCE GENERATOR TRANSFORMATION
STORED PROCEDURE TRANSFORMATION
LOOKUP TRANSFORMATION (Upgradations in 9.X)
XML SOURCE Qualifier Transformation.

c). CONNECTED AND UNCONNECTED TRANSFORMATIONS.

d). FLAT FILES AND ITS TYPES.

POWER CENTER ADVANCED

1). Unconnected lookup Transformation
2).Unconnected Stored Procedure to Create and Drop Index
3). Mapplet And Types Of Mapplets
4). Defining Reusable Transformations.
5). User Defined Functions.
6). Tasks And Types Of Tasks.
7). Worklet and Types OfWorklets.
8). Scheduling Work flow
9). Constraint Based Laod Ordering.
10). Target Load Plan
11). Types Of Batch Processing
12). Link conditions
13).Mapping Parameters
14).Mapping Variables
15).Defining Session Parameters
17).Session Recovery
18). Difference Between Normal and Bulk Loading.
19). Push Down Optimization.
20). PMCMD Utility
21).PMREP Utility
22).Incremental Aggregation

TYPES of LookUp Caches.

·         Static LookUp Cache

·         Dynamic LookUp Cache

·         Persistence lookUp Cache

·         Shared LookUp Cache

24). Sorter and Rank Cache.

25). ETL UNIT Testing (8 test Cases)
26). ETL PERFORMANCE TESTING (3 test cases)
27). ETL Performance
Optimization techniques

Task Implementations. 

·         Session

·         Command

·         EMAIL

·         Timer

·         Event Wait

·         Event Raise

·         Decision

·         Assignment

·         Control

·         Worklet