DSXchange

Sure. Make sure your data is sorted by Id and it looks like Note going in. In your transformer have 3 stage variables: counter, curr_value and prev_value. For each row being processed put ID in curr_value, check if curr_value = prev_value, if it does add 1 to counter, if it doesn't reset counter to ...

Is this a new installation or an upgrade from an earlier release? If the latter, you can get the (free) IBM Concierge Service to assist. Otherwise, as noted, everything you need is in the Installati ... As someone who has used the Concierge service to upgrade from 8.1 to 8.5, I can confirm that the...

What we typically do is split the update record into two streams let's call them the update stream and the insert stream. In the update stream we look up the surrogate key with curr_flg = 'Y', using that surrogate key as the key for an update only operation we set the Exp_Dt for that record and the ...