I'm working on an ETL package (General Ledger) where I use a Conditional Split to split the input into two outputs (O1 and O2) based on the Account Type. Below the Conditional Split, I use Derived Column transformations for both O1 and 02. The Derived Column transformation looks like this:
GLAmount: (DebitAmount - CreditAmount)
GLAmount: (CreditAmount - DebitAmount)
As you can see, the Derived Columns ETLDT, GroupNum and Flag are common in both O1 and O2. Also, they do not impact the Conditional Split in any way.
I am a little confused about whether I should use the same approach as mentioned above, or if I should add a separate Derived Column above the Conditional Split for the ETLDT, GroupNum and Flag derived columns, <b>in order to get optimal performance</b>.