Source Qualifier Transformation

当Source Qualifier Transformation使用sql query override的话，所有的ports按顺序连接到downstream时不能断节，可以从最后依次不连接，但是从前面或者中间不连接是不可以的，否则报错。

 

Source Qualifier Transformation支持Oracle分析函数 比如:

select a.*, max(org_wid) over()  as max_wid  from WC_POSTN_COACH_A_TEST1 a

 

Output is Deterministic

Transformation Indicates that the transformation always generates the same set of data from the same input data.The Integration Service can resume a session from the last checkpoint when the output is repeatable and deterministic.
When you enable this option with the Output is Repeatable option for a relational source qualifier, the Integration Service does not save the SQL results to shared storage.

Output is Repeatable

Transformation Indicates whether the transformation generates rows in the same order between session runs. The Integration Service can resume a session from the last checkpoint when the output is repeatable and deterministic.

When you enable this option with the Output is Deterministic option for a relational source qualifier, the Integration Service does not save the SQL results to shared storage.

Warning: If you configure a transformation as repeatable and deterministic, it is your responsibility to ensure that
the data is repeatable. If you try to recover a session with transformations that do not generate repeatable and
deterministic data, the recovery process can result in corrupted data.

 

Infa Workflow的Source instancs的Out Field和SQ Transformation的Input Field只要Datatype对应没问题就可以。