I couldn't find an example of the Datastage pivot stage and it's not very obvious how to use it. Thats why i've created this page. It shows an example of how you use it.
The output link has two columns. The jobname and one for the function names. Per input row, there are 10 rows outputted. Even if the fields are NULL. Divide the fieldnames with spaces, not with any other delimiter.