Can DMS do mapping that is not simply 1-1 from source to target?

Question

How can DMS do more complex mapping that is not simply 1-1 from source to target? 
For example, if you need to check for data across multiple tables for some business logic and based on those results, map a certain string over to the target.

Accepted Answer

DMS cannot perform complex business logic across multiple tables.

You may want to consider performing the complex logic in the source table itself using views or triggers/procedures. You can then use the resulting view or table as a source for DMS. Note: AWS DMS loads views only in a full-load task.

Answer

You can migrate many to 1 target using multiple dms tasks and multiple staging target tables. Once the data is in target db you can aggregate or merge as per your need.

Can DMS do mapping that is not simply 1-1 from source to target?

相关内容