PowerCenter - Targets

Card Puncher Data Processing

About

PowerCenter can load data into the following targets:

  • Relational. Oracle, Sybase ASE, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, and Teradata.
  • File. Fixed and delimited flat file and XML.
  • Application. You can purchase additional PowerCenter Connect products to load data into business sources such as Hyperion Essbase, IBM MQSeries, IBM DB2 OLAP Server, JMS, Microsoft Message Queue, mySAP, PeopleSoft EPM, SAP BW, SAS, Siebel, TIBCO, and webMethods.
  • Mainframe. You can purchase PowerExchange to load data into mainframe databases such as IBM DB2 OS/390, IBM DB2 OS/400, and VSAM.
  • Other. Microsoft Access and external web services.

You can load data into targets using ODBC or native drivers, FTP, or external loaders.

A target is design with the target designer.

Powercenter Workflow Manager Connections

Target definitions

Target definitions define the structure of tables in the target database, or the structure of file targets the integration service creates when you run a session. If you add a relational target definition to the repository that does not exist in a database, you need to create target table. You do this by generating and executing the necessary SQL code within the target designer. Menu > Targets > Generate/Execute SQL

Bulk Load Oracle Guidelines

Bulk Load is a property of a task for a target table.

When bulk loading to Oracle, the Integration Service invokes the SQL*Loader.

Use the following guidelines when bulk loading to Oracle:

  • Do not define CHECK constraints in the database.
  • Do not define primary and foreign keys in the database. However, you can define primary and foreign keys for the target definitions in the Designer.
  • To bulk load into indexed tables, choose non-parallel mode and disable the Enable Parallel Mode option.

Note that when you disable parallel mode, you cannot load multiple target instances, partitions, or sessions into the same table. To bulk load in parallel mode, you must drop indexes and constraints in the target tables before running a bulk load session. After the session completes, you can rebuild them. If you use bulk loading with the session on a regular basis, use pre- and post-session SQL to drop and rebuild indexes and key constraints.

  • When you use the LONG datatype, verify it is the last column in the table.
  • Specify the Table Name Prefix for the target when you use Oracle client 9i. If you do not specify the table name prefix, the Integration Service uses the database login as the prefix.

Pre and post-session SQL are property of the session task on a Source Qualify transformation or target table. The Integration Service runs:

  • pre-session SQL commands before it reads the source.
  • post-session SQL commands after it writes to the target.

Documentation / Reference

  • PowerCenter Workflow Basic Guide - page 88 Chapter 7 Bulk Loading





Discover More
Card Puncher Data Processing
PowerCenter - DataType (Conversion)

The Designer displays two types of datatypes: Native datatypes. Specific to the source and target databases, flat files, or ERP systems. Native datatypes appear in the Source Analyzer and Target Designer....
Powercenter Designer Tools
PowerCenter - Designer

The Designer has the following tools that you use to analyze sources, design target schemas, and build source-to-target mappings: . Import or create source definitions. . Import or create target definitions....
Powercenter Integration Service
PowerCenter - Integration Service

The PowerCenter Integration Service is an application service that runs workflows and sessions for the PowerCenter Client. The Integration Service reads workflow information from the repository. The...
Powercenter Mapping Pass Through
PowerCenter - Mapping

Mapping depict the flow of data between source and targets. A Pass-Through mapping inserts all the source rows into the target. To create and edit mappings, you use the Mapping Designer tool in the...
Card Puncher Data Processing
PowerCenter - Repository Objects

You create repository objects using the and client tools. You can also view the objects in the Navigator window of the . source definitions. Definitions of database objects (table, views, synonyms)...
Powercenter Workflow Sample
PowerCenter - Sessions

A session is a type of workflow task. A session is a set of instructions that tells the integration service how to move data from sources to targets using a mapping. You create a session for each mapping...
Powercenter Designer Tools
PowerCenter - Target Designer

PowerCenter Target Designer is a tool of designer and its aim is to design target To launch it designer > Tool > Target_designer “” Before using this screen, you must have minimum one target...
Card Puncher Data Processing
PowerCenter - Xml

XML is a common means of exchanging data on the web. Use XML files as a source of data and as a target for transformed data. The designer represents an XML hierarchy in an XML definition as a set of views....
Powercenter Xml Relationship Pk
PowerCenter - Xml Target

Powercenter Xml Target In the , switch to the . If the workspace contains targets, you can clear them with a right-click on the workspace. Click Targets > Import XML Definition. Navigate and...
Card Puncher Data Processing
Powercenter - Design API Sdk

You can use the Design API to read and create PowerCenter design objects. Sources and targets Transformations Mappings and mapplets Sessions, tasks, and workflows Runtime parameter files Use...



Share this page:
Follow us:
Task Runner