Saturday, February 12, 2011

powercent Developer


The following things are displayed in Designer

Navigator

It connect to repositories, and open folders within the Navigator. we can also copy objects and create shortcuts within the Navigator.

Workspace

It opens different tools in this window to create and edit repository objects, such as sources, targets, mapplets, transformations, and mappings.

Output

View details about tasks you perform, such as saving your work or validating a mapping.

Status bar

It Displays the status of the operation you perform.


Overview

An optional window to simplify viewing a workspace that contains a large mapping or multiple objects. Outlines the visible area in the workspace and highlights selected objects in color.

Instance data

View transformation data while you run the Debugger to debug a mapping.

Target data

View target data while you run the Debugger to debug a mapping.

PowerCenter 8 Client

PowerCenter Client consists of the following applications that we use to manage the repository, design mappings, mapplets, and create sessions to load the data.

Designer

Designer is used to create mappings that contain transformation instructions for the Integration Service. The Designer has the following tools that we use to analyze sources, design target schemas, and build source-to-target mappings


Source Analyzer

It imports or creates source definitions

Target Designer


It imports or creates target definitions.

Transformation Developer

Develop transformations to use in mappings. we can also develop user-defined functions to use in expressions.


Mapplets Designer

It Creates sets of transformations to use in mappings.

Mapping Designer

It Creates mappings that the Integration Service uses to extract, transform, and load data

PowerCenter 8 Administration Console


Administration Console is a web application that we use to manage a PowerCenter domain. If you have a user login to the domain, we can access the Administration Consol to perform administrative tasks such as managing logs, user accounts, and domain objects. Domain objects include services, nodes, and licenses. Administration Console perform the following tasks in the domain.


Manage application services
Configure nodes
Manage domain objects
View and edit domain object properties
View log events