Visual Looping
Posted: Mon Apr 30, 2001 5:42 am
I would like to how to visually build a loop. I have summarised data of one record, which I want to use with a large data table to create percentage values.
Currently I am using a Transform with the summarised data as the stream and the data table as the reference and I am only getting one record returned (it does the calculation though!).
How do I get DataStage to use the total record for every record it finds in the data table, without reverting to coding it?
Stephen O
Currently I am using a Transform with the summarised data as the stream and the data table as the reference and I am only getting one record returned (it does the calculation though!).
How do I get DataStage to use the total record for every record it finds in the data table, without reverting to coding it?
Stephen O