Database Reference
In-Depth Information
delete the source qualifier of the
DEPARTMENT
table and drag all the columns
from the
DEPARTMENT
source definition into the
EMPLOYEE
source qualifier, as
shown in the following screenshot:
Link the required columns from the source qualifier to the target as per your re-
quirement.
2. Open the
Properties
tab of the Source Qualifier transformation and generate the
default SQL. Now, you can modify the default generated query as per your re-
quirement, to perform the join on the two tables.
Using this feature helps make our mapping simple by avoiding the Joiner transformation
and, in turn, helps in faster processing. Note that you cannot always replace a joiner with a
source qualifier. This option can be utilized only if you wish to join the data at the source
level and both your sources are relational tables in the same database and connection. You
can use a single source qualifier to join the data from multiple sources; just make sure the
tables belong to same database scheme.
Sorting the data
You can also use the Source Qualifier transformation to sort the data while extracting the
data from the database table. When you use the sorted port option, Integration Service will
add defined ports to the
ORDER BY
clause in the default query. It will keep the sequence
