This may be a newbie question/solution but I can't find a good way to implement the proper combination of reader and transformer parameters in order to streamline my workbench definition. Here is the scenario:
Multiple readers with a huge amounts of records (all PostGIS tables).
One reader is the 'Master' table which contains rows with unique IDs. The other tables have 1:Many rows with foreign keys associated with the unique ID.
My objective is to not have every record read in each of the "supporting" tables once a result set is obtained from an initial query on the "master" reader/table.
So, let's say that I set up a WHERE Clause on the master reader/table where it returns 1000 distinct records/IDs. How do I set up the workspace so that when supporting readers/tables are accessed, only a limited set is saught and returned from each of the supplimentary readers/tables and then joined.
So, in summary, it is going through the process of creating a result set, then using that result set in a before-transaction query process for each remaining reader.
Thanks very much in advance.