Multiple functionality in the single Query Transform
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.
Gokul Gawande replied
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.