2 Answers
- Newest
- Most votes
- Most comments
1
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.
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.
answered 2 years ago
Relevant content
- asked 2 years ago
- AWS OFFICIALUpdated 6 months ago
- Why is no data migrated from my Amazon S3 source endpoint even though my AWS DMS task is successful?AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago