PowerCenter - Repository Objects

Card Puncher Data Processing

About

You create repository objects using the PowerCenter - Designer and PowerCenter - Workflow Manager client tools.

You can also view the objects in the Navigator window of the PowerCenter - Repository Manager.

In a mapping

  • source definitions. Definitions of database objects (table, views, synonyms) or files (xml, …)that provide source data.
  • target definitions. Definitions of database objects or files that contain the target data.
  • mapping. A set of source and target definitions along with transformations containing business logic that you build into the transformation. These are the instructions that the Integration Service uses to transform and move data.
  • Reusable transformations. transformation that you use in multiple mappings.
  • Mapplets. A set of transformations that you use in multiple mappings.

In a workflow

Metadata

SELECT
  object_type_name
FROM
  PC8DVL.opb_object_type
ORDER BY
  object_type_name ASC;
  • Abort
  • Advanced External Procedure
  • Aggregator
  • App Multi-Group Source Qualifier
  • Application
  • Application Source Qualifier
  • Assignment
  • Batch
  • Business Component
  • Business Component Framework
  • Command
  • Control
  • Cube
  • Custom Transformation
  • Database Object
  • Decision
  • Deployed Deployment Group
  • Deployment Group
  • Dimension
  • Email
  • Event Raise
  • Event Wait
  • Expression
  • External Loader
  • External Procedure
  • Fact Table
  • File Object
  • Filter
  • Folder
  • Folder Version
  • FTP
  • FTP Object
  • General Object
  • Global Profile Resource
  • Hierarchy
  • Informix External Loader Object
  • Input Transformation
  • Joiner
  • Label
  • Level
  • Lookup Extension
  • Lookup Procedure
  • Mapping
  • Mapplet
  • Merger
  • MQ Connection Object
  • MQ Source Qualifier
  • Normalizer
  • Oracle External Loader Object
  • Output Transformation
  • Pivot
  • Procedure
  • Profiling Ruleset
  • Query
  • Queue
  • Rank
  • Reader
  • Relational
  • Repository
  • Router
  • SAP Function
  • SAP Structure
  • Scheduler
  • Sequence
  • Server Grid
  • Server Object
  • Service Level
  • Session
  • Session Obsolete
  • SessionConfig
  • Shortcut
  • Sorter
  • Source Definition
  • Source Qualifier
  • Star Schema
  • Start
  • Stop
  • Stored Procedure
  • Sybase IQ External Loader Object
  • Sybase IQ 12 External Loader Object
  • Target Definition
  • Template Extension
  • Tera Data External Loader Object
  • Timer
  • Transaction Control
  • Update Strategy
  • User Defined Function
  • Vendor
  • Web Services Hub
  • Workflow
  • Worklet
  • Writer
  • XML Source Qualifier





Discover More
Powercenter Repository Manager Window
PowerCenter - Repository Manager

Use the Repository Manager to administer repositories. You can navigate through multiple folders and repositories, and complete the following tasks: Manage users and groups. Create, edit, and delete...
Card Puncher Data Processing
PowerCenter - Repository Reports

PowerCenter Repository Reports are a set of prepackaged reports and dashboards to help you analyze and manage PowerCenter metadata. Use PowerCenter Repository Reports to browse and analyze PowerCenter...



Share this page:
Follow us:
Task Runner