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
Require more information on datastage 8.5 transformer stage
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm
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.
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.
"Don't let the bull between you and the fence"
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Hi,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.
I am also facing heap error with the above functions, did IBM resolve your issue, was any patch provided ?
Thanks
- Zulfi