Hi Experts,
Is there a way we can set the value of variable at run time in one transform and access that variable in some other transforms later in the same data flow?
We can set variables in pre/post loads but this does not allow us to set the variable values from within a transform.
For example say I want to set the total record count n in a transform A and then access that count to calculate the batch number in a query transform C after an XML Batch transform B in between. (In this example I am assuming we know the batch size x to calculate the batch count using n / x in Transform C)
Regards,
Sid