We got this working; just wanted to know if there is a better way to do this.

This is what we needed.
Query a table to get the "Tenants" and the "Source Versions" records. Loop through the records and call different transformations based on the "Source Version".

This is how we accomplished this.
Parent Job --> calls a Transformation which has a "Table Input" and a "Copy Rows to Result" step --> Child Job which "Executes for every input row" and "copies pervious result set to parameters", which calls the version specific Transformation based on the Source Version parameter (eg:${repo_path}/prep_pg_stream_${analytics_version}.ktr).

We tried to use "Execute SQL" to get the records in the job instead of using Transformation, but that doesn't seem to pass the Result Set to parameters. We are trying to see if there is a way to avoid the additional Transformation and Job in here, for this simple looping.

Thanks in advance.
Name:  loop_setup.jpg
Views: 30
Size:  7.3 KB