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개 답변
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.

AWS
vg
답변함 2년 전
profile picture
전문가
검토됨 한 달 전
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
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠