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 Source Session Properties

Configure Db2 Warehouse Source Session Properties

You can configure the session properties for a Db2 Warehouse source on the Mapping tab. Define the properties for each source instance in the session.
The following table describes the session properties that you can configure for a Db2 Warehouse source session:
Property
Description
Delimiter
Delimiter separates successive input fields in the Db2 Warehouse external table. You can enter any value supported by Db2 Warehouse.
The value can be a part of the data for the Db2 Warehouse source. 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 an external table. If the data contains NULL, CR, and LF characters in the Char or Varchar field, you need to add an escape character in the source data before extracting.
Enter an escape character before the data. The supported escape character is backslash (\).
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 extracting data from the source.
Db2 Warehouse Post SQL
SQL statement that the PowerCenter Integration Service executes after extracting data from the source.
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.
0 COMMENTS
We’d like to hear from you!