The Definitive Guide to Data Quality
If I'm not wrong you want to use the results of your main query as a sub query resultset / condition to your 12 additional queries?
Why don't you use tMap and try joining your main query and to these 12 different queries?
You can also store your main query result in tHashMap (input and output) components, kind of temporary table.
Parameterised query is possible assigning variables to your query component, so if you are talking about 100 rows from your main query, then you are bound to iterate 100 times to get your result?
Hope this helps.