Informatica Common Component Source Qualifier Create sq conversion

You can configure Designer to create source qualifier conversions by default when you drag the source into the map, or you can manually create a source qualifier transformation.

Default creation of Source qualifier conversions

You can configure Designer to automatically create a source qualifier conversion when you drag the source into the map.

To automatically create a source qualifier transformation:

• In the Designer, select Tools-Options.

• Select the Format tab.

• In the Tools option, select Mapping Designer.

• Select Create Source Qualifier when you open the source.

Create source Qualifier conversions manually

Source qualifier conversions can be created manually in Mapping Designer.

To manually create a source qualifier transformation:

• In Mapping Designer, select Convert-Create.

• Enter a name for the transformation and click Create.

• Select the source and click OK.

• Click Finish.

Configure Source Qualifier Conversion options

After you create a source qualifier transformation, you can configure some options.

Create source Qualifier conversions manually

Source qualifier conversions can be created manually in Mapping Designer.

To manually create a source qualifier transformation:

• In Mapping Designer, select Convert-Create.

• Enter a name for the transformation and click Create.

• Select the source and click OK.

• Click Finish.

Configure Source Qualifier Conversion options

After you create a source qualifier transformation, you can configure some options.

To configure the Source qualifier transformation:

• Open the map in Designer.

• Double-click the title bar of the source qualifier transformation.

• In the Edit Transform dialog box, click Rename, enter a descriptive name for the transformation, and then click OK.

The naming convention for source qualifier conversions is sq_transformationname, such as sq_allsources.

• Click the Properties tab.

• Enter any additional settings that you want:

  Options	Description
  SQL Query	Defines a custom query that overrides the default query, and PowerCenter uses the default query to read data from the source represented in the Source qualifier transformation. Custom queries will overwrite custom join entries or source filter entries.
  User-defined Joins	Specifies the criteria used to join data from multiple sources in the same source qualifier transformation.
  SOURCE Filter	Specifies the filter criteria that PowerCenter Server applies when querying rows.
  Number of sorted ports	Indicates the number of columns to use when arranging rows queried from a relational source. If you select this option, PowerCenter Server adds an ORDER by to the default query when the source row is read. The ORDER by includes the specified number of ports, starting at the top of the conversion. When selected, the database order must match the order in which the sessions are arranged.
  Trace level	Sets the amount of detail contained in the session log when running a session that contains this transformation.
  Select dissimilar	Specifies whether you want to select only unique rows. If you select this option, PowerCenter Server will include the Select DISTINCT statement.
  Pre-SQL	PowerCenter Server reads pre-session SQL commands on the source database before the source is read.
  Post-SQL	PowerCenter Server writes a post-session SQL command after the target is running on the source database.

• Click the Source tab and indicate any associated source definitions that you want to define for this transformation.

　　Identify the associated source only if you need to join data from multiple databases or flat file systems.

• Click OK to return to the Designer.

Informatica Common Component Source Qualifier Create sq conversion