DSXchange

Test it out. The processing will not start untill both source and hashed file for the transformer are ready. But as a standard practice, build hashed files in a seperate job. This way if you have to restart your job, the hashed files wont have to be built from scratch.

10000 rows is not large for a hashed file, particularly if you've only loaded the columns you actually need from the DB2 table.