PowerCenter - Repository Objects

1 - 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.

3 - 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.

4 - In a workflow

5 - 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
dit/powercenter/repository_objects.txt · Last modified: 2017/10/23 16:32 by gerardnico