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>

Visit the Informatica Cloud Community for additional details and examples. You can browse or search for "session properties".