title: AWS DMS - join source tables while migrating
body: <p>My current requirement is to migrate an on premise Oracle DB to Aurora MySql in AWS. One question I had was, is it possible to join data from multiple tables in source during the migration. For example, can 2 tables be joined and the resulting data be loaded to a single table in target using DMS.</p>