Can DMS do mapping that is not simply 1-1 from source to target?
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.
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.
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.
Do source filters speed up DMS from AWS RDS to S3?asked 6 months ago
DMS Support for mapping rules - dynamodb-map data typeasked 14 hours ago
DMS - How to retain non-ASCII values when running DMS task from MySQL source to Redshift targetasked 3 months ago
DMS service for aurora postgres doesnt accept a view as source for full load processasked 3 months ago
Can DMS do mapping that is not simply 1-1 from source to target?Accepted Answerasked a month ago
Connecting DMS to our local source endpointasked 25 days ago
Amazon DMS table mapping tranformationasked 5 months ago
Does DMS support updating value of sequences in the target for postgres to postgres data migration?asked a month ago
DMS CDC VerificationAccepted Answerasked 3 years ago
DMS supports Super type for Redshift target with MongoDB sourceasked 2 months ago