| |
Source Qualifier(SQ) is a active transformation. |
| |
SQ is used to read the relational or flatfile source tables |
|
| |
SQL override in SQ : To override the default query. |
|
| |
Join Condition in SQ : To join more than two tables |
|
|
Filter Condition in SQ : Filter the source records |
|
| |
Sorted ports : Add the ports to the order by clause in the default query |
|
| |
Distinct : select the distinct records from the source |
|
| |
Pre-SQL: power center server(PCS) executes pre-sql before it reads the source data |
|
| |
Post-SQL: PCS executes post-sql quey after data return to the target |
|
| |
|
