In the source system, the tables are generated dynamically , so we never know the source table in advance.
(Current logic is in java , where it runs a loop on a table from which it gets to know the source table name to form a oracle query which is passed to pentaho API.
Pentaho API calls the pentaho process which runs the query and populate the target tables.)
We are planning to move this logic in SAP BODS.