1 Answer
- Newest
- Most votes
- Most comments
0
Hello,
In order to perform an Object Mapping and Transformation Rule, you would be required to separate them into their own rule set. An example can be seen below: [1]
{
"rules": [
{
"rule-type": "selection",
"rule-id": "1",
"rule-name": "1",
"object-locator": {
"schema-name": "%",
"table-name": "USER_SAVED_SEARCHES_TBL"
},
"rule-action": "include"
},
{
"rule-type": "transformation",
"rule-id": "2",
"rule-name": "2",
"rule-action": "add-column",
"rule-target": "column",
"object-locator": {
"schema-name": "%",
"table-name": "USER_SAVED_SEARCHES_TBL"
},
"value": " startTime",
"expression": "CASE WHEN $START_TIME==-1 THEN null ELSE $START_TIME END",
"data-type": {
"type": "datetime"
}
}
]
}
References:
[1] Expressions: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Expressions.html
Relevant content
- asked 7 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago