Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Db2 Warehouse
  3. PowerExchange for Db2 Warehouse Configuration
  4. Db2 Warehouse Sources and Targets
  5. Db2 Warehouse Sessions and Workflows
  6. Data Type Reference

PowerExchange for Db2 Warehouse User Guide for PowerCenter

PowerExchange for Db2 Warehouse User Guide for PowerCenter

Back Next

Configure Db2 Warehouse Target Session Properties

Configure Db2 Warehouse Target Session Properties

You can configure the session properties for Db2 Warehouse targets in the Transformations view on the Mapping tab. Define the properties for each target instance in the session.
The following table describes the session properties that you can configure for a Db2 Warehouse target session:
Property
Description
Insert
Inserts all rows to the Db2 Warehouse target.
Default is true.
Delete
Deletes rows from the Db2 Warehouse target.
If you select DELETE, you need to select
Delete
 for the
Treat source rows as
 session property in the
Properties
 page.
Update
Updates rows in the Db2 Warehouse target.
If you select UPDATE, you need to select
Update
 for the
Treat source rows as
 session property in the
Properties
 page.
You can select one of the following modes:
  • Update as Update. PowerExchange for Db2 Warehouse updates all rows flagged for update if the entries exist.
  • Update else Insert. PowerExchange for Db2 Warehouse first updates all rows flagged for update if the entries exist in the target. If the entries do not exist, PowerExchange for Db2 Warehouse inserts the entries.
  • Update as Insert. PowerExchange for Db2 Warehouse inserts all rows flagged for update if the entries do not exist in the target.
Truncate Target Table Option
The PowerCenter Integration Service truncates the target before loading. Run the truncate table command. Default is disabled.
If you specify an SQL statement in the Pre-SQL property, the PowerCenter Integration Service runs the SQL statement before the table is truncated.
Delimiter
Delimiter separates successive input fields in the Db2 Warehouse external table. You can enter any value supported by Db2 Warehouse.
The value must not be a part of the input data. Default is the pipe (|) character.
Null Value
NullValue parameter of the Db2 Warehouse external table. The PowerCenter Integration Service uses the NullValue internally.
Maximum value is one character. Default is NULL.
Escape Character
Escape character of the external table. If the data contains NULL, CR, and LF characters in the Char or Varchar field, you need to add an escape character for these fields before loading.
Enter a backslash (\) as the escape character. Default is blank.
Quoted Value
QUOTEDVALUE parameter of the external table. Select SINGLE or DOUBLE to enclose the field in single or double quotes.
Select NO to omit quotes. Default is NO.
The quoted value is not a part of the data.
Socket Buffer Size
Set the socket buffer size to 25 to 50 % of the DTM buffer size to increase session performance. You might need to test different settings for optimal performance.
Enter a value between 4096 and 2147483648 bytes.
Default is 8388608 bytes.
Db2 Warehouse Pre SQL
SQL statement that the PowerCenter Integration Service executes before loading data into the target.
Db2 Warehouse Post SQL
SQL statement that the PowerCenter Integration Service executes after loading data into the target.
Pipe Directory Path
Path for the PowerCenter Integration Service to create the pipe for the external table. If you do not specify the path, the PowerCenter Integration Service uses the
$PMTempDir
 directory to create the pipe for the external table.
Error Log Directory Name
Error log directory can reside on the machine where the PowerCenter Integration Service runs. For example, you can use the following directory:
$PMBadFileDir
The PowerCenter Integration Service creates a bad file in the error log directory if the data is not valid.
0 COMMENTS
We’d like to hear from you!