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.
asked a month ago38 views
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.
answered a month 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 a month ago
Relevant questions
Do source filters speed up DMS from AWS RDS to S3?
asked 6 months agoDMS Support for mapping rules - dynamodb-map data type
asked 14 hours agoDMS - How to retain non-ASCII values when running DMS task from MySQL source to Redshift target
asked 3 months agoDMS service for aurora postgres doesnt accept a view as source for full load process
asked 3 months agoCan DMS do mapping that is not simply 1-1 from source to target?
Accepted Answerasked a month agoConnecting DMS to our local source endpoint
asked 25 days agoAmazon DMS table mapping tranformation
asked 5 months agoDoes DMS support updating value of sequences in the target for postgres to postgres data migration?
asked a month agoDMS CDC Verification
Accepted Answerasked 3 years agoDMS supports Super type for Redshift target with MongoDB source
asked 2 months ago