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

0

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.

2 Answers
1
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.

AWS
vg
answered 2 years ago
0

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.

AWS
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions