Informatica Common Components Source Qualifier Distinct

If you want PowerCenter to select unique values from the source, you can use the Select different option. For example, you can use this feature to extract unique customer identities from a table that lists total sales. Using the Select Dissimilar filter allows you to filter out unnecessary data earlier, which can help improve performance.

By default, the Designer generates a SELECT statement. If you select Select Different, the Source qualifier transformation will include this setting in the default SQL query.   

       For example, enable the Select dissimilar option. Designer will add the SELECT DISTINCT to the default query as follows:  

SELECT DISTINCT       CUSTOMERS. customer_id,       Customers.company,      CUSTOMERS. First_Name,       CUSTOMERS. last_name,      CUSTOMERS. ADDRESS1,       CUSTOMERS. ADDRESS2,       CUSTOMERS. City,      CUSTOMERS. State,       CUSTOMERS. Postal_Code,       CUSTOMERS. PHONE,       CUSTOMERS. EMAIL,      ORDERS. order_id,      ORDERS. date_entered,       ORDERS. date_promised,       ORDERS. date_shipped,       ORDERS. employee_id,       ORDERS. customer_id,       ORDERS. Sales_tax_rate,       ORDERS. store_id       fromWHERE CUSTOMERS. customer_id=ORDERS. customer_id

Select Distinct

However, if you modify the default query after selecting Select different, PowerCenter will only use the query defined in the SQL query properties. That is, the SQL query overrides the select dissimilar setting.

To use Select dissimilar:

• Open the Source qualifier transformation in the map, and then click the Properties tab.

• Select Select Different, and then click OK.

Overwrite "select Dissimilarity" in a session

When you configure a session in Workflow Manager, you can override the conversion level option "choose Dissimilar".

To override the Select dissimilar option:

• Open the sessions task in Workflow Manager, and then click the Mappings tab.

• Click Convert View, and then click Source Qualifier conversion under the source node.

• In the Properties setting, enable select different, and then click OK.

Informatica Common Components Source Qualifier Distinct