Require more information on datastage 8.5 transformer stage

ksv2584 · Post by **ksv2584** » Wed Feb 23, 2011 2:19 am

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

chulett · Post by **chulett** » Wed Feb 23, 2011 8:19 am

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.

greggknight · Post by **greggknight** » Wed Feb 23, 2011 10:33 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 23, 2011 8:40 pm

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

zulfi123786 · Post by **zulfi123786** » Thu Sep 25, 2014 11:12 am

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