DSXchange

Please try to come up with more descriptive subject lines, pretty much everything here is a "scenario that needs to be solved". Also, rather than force people to puzzle out the relationship between the input and the ouput examples, it is always best to spell out your requirements in words....

Or open the stage and then click on the Help button that each stage has inside.

And?

Yes, I would be curious what exactly you are trying to loop thru and how it is being generated.

... but of course! :D

That, too.

I don't see anything about this that requires two transformers. It's just a running subtotal and you can do all that in one transformer along with the 'group change detection' you are doing.

I understand that that ETLStats is not free. Your understanding is wrong. Completely free, thanks to the generosity of Kim Duke. 8) Is it really possible to get these details from the job itself? Yes, use the DSGet* functions such as DSGetJobInfo() and DSGetLinkInfo() for that. There are dsjob equi...

... or perhaps another set of eyeballs.

It's not a small wheel. :wink: Even if you don't use it directly, ETLStats will give you ideas on how you can 'roll your own' and the APIs and techniques you can use to satisfy your requirement. As with most things, there are multiple ways to approach this and it's not really a subject that fits wel...

Something that is a little confusing is you keep using "input" and "output" but with the opposite meaning from the stage's standpoint. For us it makes sense to think of "input" as the stage reading and "output" as the stage writing but when it comes to the rea...

While I believe that you can install the compiler after you install DataStage, the best thing to do would be to install the compiler first so the DataStage installer can find it and configure things properly. Afterwards, that configuration becomes more... manual.

Well... if you really need a response: sorry, no clue. The documentation I have isn't much help, either, nor is Google. Why not ask your official support provider and post the answer back here?

Spell out your requirement in words.