First 3 Records in Target1, Next 5 Records in Target2 and Rest Target3

[@etlguru]

The first 3 Records are in T1, the Next 5 Records in T2 and the Rest in T3 SRC->SQ->EXP->RTR-TGT1,2,3 EXP ----- v_CNT=v_CNT+1 CNT_1_3 = IIF(v_CNT=4 AND v_CNTT1 Group_Target2=CNT_4_8----->T2 Default1------->T3

[@anil.vattamwar]

From where v_CNT took reference in expression transformation ? I mean Without input ports how v_CNT calculating

[@etlguru]

The Integration Service uses a default value based on the datatype for the Numeric datatype it is 0, for the String datatype it is empty string and for the date datatype it is 1/1/1753 AD for more details refer docs.informatica.com/data-integration/powercenter/10-5/advanced-workflow-guide/workflow-variables/user-defined-workflow-variables/datatype-default-values.html