I want to backup hundreds of schema/files from SalesforceDB to postgreSQL. The Salesforce schemas/files are under
Repository>Metadata>Salesforce>myDB>.
In the case of several schemas/ files need to backup, I use Designer to build the job:
SFfile1->tMap1->tPostgresqlOutput_1
| OnSubjobOK
SFfile2->tMap2->tPostgresqlOutput_2
| OnSubjobOK
SFfile3->tMap3->tPostgresqlOutput_3
...
But now I have hundreds of Salesforce files to be backup. Since the subjobs have the same structure, I guess there must be programatic way to do it, instead of manually building subjob one by one. NOW HOW?