Multiple functionality in the single Query Transform

[Former Member]

I want to use the Order by and Join in the same Query Transform, instead of having multiple query transforms. Is there is any restriction of usage of multiple query transforms in the same data flow? If so, how many transforms were allowed per data flow?  Why because, I come from the background of Datastage, there is a restriction is using multiple stages.

Kindly show some light on this.

Thanks

[Former Member · Accepted solution]

Hello Raja,

There are no such restrictions actually. It depends on your logic.

And you can do the join and order by in same query transform

PS - Video's available on youtube and other website might help you to get through the basics of BODS.

Regards,

Gokul

[Former Member · Accepted solution]

Raja,

Close the thread if your question is answered or let me know if you have any doubt.

Regards,

Gokul

[Former Member]

Hi Raja,

Please close your other threads as well if that is been answered. This way it is really helpful for other users who are facing the same problem to pick up the correct solution

Regards,

Gokul