Number of sorted input @ Source Qualifier Transformation

You get an option "Number of Sorted Inputs"  at source qualifier tranformation.

Here the value is 3 [default its 0]. At source qualifier there are only 3 columns and now if you run the session, below is the query got generated

Severity    Timestamp    Node    Thread    Message Code    Message
INFO    1/7/2009 4:26:08 AM    node01_mandar    READER_1_1_1    RR_4010    SQ instance [SQ_RESOURCE_DIM] SQL Query [SELECT RESOURCE_DIM.ID, RESOURCE_DIM.NAME, RESOURCE_DIM.GES_UPDATE_DATE FROM RESOURCE_DIM ORDER BY RESOURCE_DIM.ID, RESOURCE_DIM.NAME, RESOURCE_DIM.GES_UPDATE_DATE]

Here, as we have selected 3 as number of sorted ports, first 3 columns got added at sql over-ride of source qualifier.

What will happen if give value as 5 ?

As there are no 5 ports exists, Informatica server did not add any port at order by clause - because we give incorrect information.

Severity    Timestamp    Node    Thread    Message Code    Message

INFO    1/7/2009 4:35:04 AM    node01_mandar    READER_1_1_1    RR_4010    SQ instance [SQ_RESOURCE_DIM] SQL Query [SELECT RESOURCE_DIM.ID, RESOURCE_DIM.NAME, RESOURCE_DIM.GES_UPDATE_DATE FROM RESOURCE_DIM]

What will happen if give value as 1 ?

This time, informatica server added first port at source qualifier tranformation over-ride.

Severity    Timestamp    Node    Thread    Message Code    Message

INFO    1/7/2009 4:36:49 AM    node01_mandar    READER_1_1_1    RR_4010    SQ instance [SQ_RESOURCE_DIM] SQL Query [SELECT RESOURCE_DIM.ID, RESOURCE_DIM.NAME, RESOURCE_DIM.GES_UPDATE_DATE FROM RESOURCE_DIM ORDER BY RESOURCE_DIM.ID]