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",
		
	}
}
已提问 2 年前68 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则