PowerCenter Architecture & Administration

Syllabus for Informatica PowerCenter 7 Architecture and Administration Exam

The PowerCenter 7 Architecture and Administration examination is composed of the twelve sections listed below. In order to ensure that you are prepared for the test, review the subtopics associated with each section. The Informatica documentation is an excellent source of information on the material that will be covered in the examination. If you are thoroughly knowledgeable in the areas mentioned in this Skill Set Inventory, you will do well on the examination.

The examination is designed to test for "expert level" knowledge. Informatica strongly urges you to attain a complete understanding of these topics before you attempt to take the examination. Hands-on experience with the software is the best way to gain this understanding.

1. Application components

  • Know what operations can be performed with each client tool (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
  • Know the purpose and uses for each of the windows in the client tools (Output window, Details window, Navigator window, Task View, Gantt Chart View, etc).
  • Be able to specify which components are necessary to perform various development and maintenance operations.

2. Nomenclature

  • Be able to define all object types and properties used by the client and server tools.
  • Be familiar with the properties of the Repository server and the Informatica server.
  • Know the meaning of the terms used to describe development and maintenance operations.
  • Know how to work with server variables.
  • Understand the relationships between all PowerCenter object types.
  • Know which tools are used to create and modify all objects.

3. Repository server

  • Know how each client and server component communicates with relational databases.
  • Be familiar with the connectivity options that are available for the different tools.
  • Understand how the client and server tools access flat files, COBOL files, and XML files.
  • Know the requirements for using various types of ODBC drivers with the client tools.
  • Know the meaning of all database connection properties.
  • Be familiar with the sequence of events involving starting the Repository server.
  • Know which repository operations can be preformed from the command line.

4. Installation

  • Understand the basic procedure for installing the client and server software.
  • Know what non-Informatica hardware and software is required for installation.
  • Be familiar with network related requirements and limitations.
  • Know which components are needed to perform a repository upgrade.
  • Be familiar with the data movement mode options.

5. Security

  • Be familiar with the security permissions for application users.
  • Be familiar with the meaning of the various user types for an Informatica system.
  • Know the basic steps for creating and configuring application users.
  • Understand how user security affects folder operations.
  • Know what passwords are needed to install new client software.

6. Object sharing

  • Understand the differences between copies and shortcuts.
  • Know which object properties are inherited in shortcuts.
  • Know the rules associated with transferring and sharing objects between folders.
  • Know the rules associated with transferring and sharing objects between repositories.

7. Repository organization and migration

  • Understand the various options for organizing a repository.
  • Be familiar with how a repository stores information about its own properties.
  • Be familiar with metadata extensions.
  • Know the capabilities and limitations of folders and other repository objects.
  • Know what type of information is stored in the repository.

8. Database connections

  • Understand the purpose and relationships between the different types of code pages.
  • Know the differences between using native and ODBC server-side database connections.
  • Understand how and why the client tools use database connectivity.
  • Know the differences between client and server connectivity.

9. Workflow Manager configuration

  • Know what permissions are needed to perform various operations with the Workflow Manager.
  • Be able to identify which interface features in the Workflow Manager are userconfigurable.
  • Know how to register a server to the repository and the reason why this is necessary.
  • Be familiar with database, external loader, and FTP configuration using the Workflow Manager

10. Workflow properties

  • Be familiar with all user-configurable Workflow properties.
  • Know what permissions are required to make all possible changes to Workflow properties.
  • Know the reasons why a Workflow may fail and how these reasons relate to the Workflow properties.
  • Know the rules for linking Tasks within a Workflow.
  • Be familiar with the properties and rules of all types of Workflow Tasks.
  • Know how to use a Workflow to read a parameter file.

11. Running and monitoring Workflows

  • Know what types of permissions are needed to run and schedule Workflows.
  • Understand how and why target rows may be rejected for loading.
  • Be familiar with the rules associated with Workflow links.
  • Understand how Tasks behave when run outside of a Workflow.
  • Know which mapping properties can be overridden on a Session Task level.
  • Know how to work with reusable Workflow schedules.

12. Workflow and Task errors

  • Know how to abort or stop a Workflow or Task.
  • Understand how to work with Workflow and Session Task log files.
  • Understand how to work with reject files.
  • Know how to use the Workflow Monitor to quickly determine the status of any Workflow or Task.

Leave a Reply