Hi All
I need to work on a MS-SQL to AWS Opensearch one time data migration
The data is in denormalized form - e.g. we have order table & order lines table
But in JSON documents in OpenSearch indexes, we need to combine the denormalized data
The order header (first 2 fields in below JSON) and the order lines have to be combined like this -
But there is way no to nest JSON documents in existing JSON. or combine 2 tables with header+details in 1 JSON document (and migrate to Opensearch).
Could someone let me know how this can be achieved using AWS DMS