AWS DMS Table Mapping Mongo Embedded document to Dynamo Table

0

how we can write a table mapping rule for this kind of JSON? any suggestion

{
	"_id" : ObjectId("6274105feb404050c7300005"),
	"ADDITIONALINFO" : {
		"PASSPORTISSUEDATE" : "01/04/2018 12:00:00 AM",
		"PASSPORTEXPIRYDATE" : "12/18/2024 12:00:00 AM",
		"IACOUNTRY" : "puk",
		"IACOUNTRYID" : "5"
	},
	"CDETAILS" : [
		{
			"CHECKID" : "1",
			"CHECKSTATUS" : "WIP",
			"REVERIFICATION" : {
				"REVERIFICATIONCOUNT" : null,
				"OLDCHECKID" : null,
				"OLDDFREFNUMBER" : null
			},
			"CHECKSTATUSID" : "1",			
			"ISSUINGAUTHORITYCOUNTRY" : "",
			"ISSUEDATE" : "02/16/2022 12:00:00 AM"
		}
	],
	"CSTAGE" : {
		"STAGEID" : "2",
		"STAGE" : "New"
	},
	"CSTATUS" : {
		"STATUSID" : "1",
		"STATUS" : "WIP",
		
	}
}
asked 2 years ago63 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions