It is a default transformation which comes with a source, it is a replica of the source.It converts the source data types into informatica compatible datatypes. It is an active trnasformation. We can not alter the datatypes of the ports in the source qualifier transformation.
Source Qualifier transformation is used in the following tasks.
Joins: By using userdefined property.
Filter: Using source filter property.
Sorting: By using number of sorted ports property.
Duplicate Removal : By using distinct property.
SQL Query: Write our own SQL query by using Sql query property.
Creating Source Qualifier Transformation
If we drag the source to the mapping designer Source Qualifier transformation is automatically created, which comes with the source.
On the other if we crete Source qulifier is
SQL query
•It is used to default source query generated bu Informatica
•To avoid unwanted columns we use this query.
•The order of the ports in the query should be same in the source.
User defined Join
It is used to join the sources in database.
Source qualifier join is used to join homogeneous relational objects, where as joins is used to join homogeneous, heterogeneous and flat files.
Source Filter
It is used to apply filter condition on tables at database.
Source Qualifier filter can be used for relational objects but filter transformation is used for all relational and flat files.
Distinct
It is used to eliminate the duplicates from the relational objects.
To eliminate duplicates from flat files we use sorter.
Pre SQL
The SQL statements will be executed before source execution.
Ex: Creating index id on table.
Creating index on source before reading the data.
Post SQL
The SQL statements will be executed after the source execution.
Ex: Drop index id on table
Dropping the index on target table before loading table.
Output is deterministic
Source code is not changed during the session run.
Output is repeatable
The source data is sorted.
Source Qualifier transformation is used in the following tasks.
Joins: By using userdefined property.
Filter: Using source filter property.
Sorting: By using number of sorted ports property.
Duplicate Removal : By using distinct property.
SQL Query: Write our own SQL query by using Sql query property.
Creating Source Qualifier Transformation
If we drag the source to the mapping designer Source Qualifier transformation is automatically created, which comes with the source.
On the other if we crete Source qulifier is
- Mappings->Cretae->Select source qualifier Transformtion->Specify name->create
- Select source and click OK
- In the mapping source and source qualifier are connected like below.
•It is used to default source query generated bu Informatica
•To avoid unwanted columns we use this query.
•The order of the ports in the query should be same in the source.
User defined Join
It is used to join the sources in database.
Source qualifier join is used to join homogeneous relational objects, where as joins is used to join homogeneous, heterogeneous and flat files.
Source Filter
It is used to apply filter condition on tables at database.
Source Qualifier filter can be used for relational objects but filter transformation is used for all relational and flat files.
Distinct
It is used to eliminate the duplicates from the relational objects.
To eliminate duplicates from flat files we use sorter.
Pre SQL
The SQL statements will be executed before source execution.
Ex: Creating index id on table.
Creating index on source before reading the data.
Post SQL
The SQL statements will be executed after the source execution.
Ex: Drop index id on table
Dropping the index on target table before loading table.
Output is deterministic
Source code is not changed during the session run.
Output is repeatable
The source data is sorted.
