DSXchange

In Datastage they hav introdces new features in transformer stage such as we can define loops that output multiple output rows from every input row or that aggregate multiple input rows into a single input row

i want to know how this is getting implemented

Thanks,
Vidya

One would typically read the documention that ships with the product for information of that nature. Or you can find other sources from people in the blog-o-sphere like our Vincent for example.

There is a new Variable called @ITERATION which you use to controll the number of loops.
like @ITERATION <= 5 will take one input row and create 5 output rows.

You also have loop variables which you can define and use just like stage variables.

Its pretty self explanatory for the basics but does have some complxaties.
I am currently using it.

Though We are having memory issues with the two new functions
GetSavedInputRecord and SavedInputRecord
Heap Allocation errors.
I am working with IBM on this right now.

Functions LastRow() and LastRowInGroup() are useful here also.

greggknight wrote:Though We are having memory issues with the two new functions
GetSavedInputRecord and SavedInputRecord
Heap Allocation errors.
I am working with IBM on this right now.

Hi,


I am also facing heap error with the above functions, did IBM resolve your issue, was any patch provided ?


Thanks