Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Object-level session properties

Object-level session properties

Object-level session properties are advanced properties based on PowerCenter session properties for transformation objects. You can configure object-level session properties for source qualifier and target objects.
For source qualifier objects, you can configure object-level session properties such as a SQL query override or pipeline partitioning attributes. Target objects allow different object-level session properties based on target type, such as null characters or delimiters for flat file targets or target load type for database targets.
Configure object-level session properties in the Session Properties field on the Properties tab of a source qualfier or target object. Use XML to configure the session properties that you want to use. Use the following syntax:
<attribute name="<session property name>" value="<value>"/>
For example, you can use the following XML to define target properties in a target object:
<attribute name ="Append if Exists" value ="YES"/> <attribute name ="Create Directory if Not Exists" value ="YES"/> <attribute name ="Header Options" value ="No Header"/>
To define partition properties, use a slightly different format. For example, to define read partitions for a database table, you could enter the following XML in the the source qualifier object Session Properties field:
<partition name="Partition1"/> <partition name="Partition2"/> <partition name="Partition3"/> <partitionPoint type="KEY_RANGE"> <ppField name="field1"> <range min="10" max="20" /> <range min="21" max="30" /> <range min="31" max="40" /> </ppField> </partitionPoint>
XML is case sensitive. Also, unlike in PowerCenter, use an underscore for the KEY_RANGE option.
Visit the Informatica Cloud Community for additional details and examples. You can browse or search for "session properties".