AWS DMS Mapping Table (MSSQL) : Loading Table data using boundaries

 MSSQL query boundaries conditions  

SELECT Max(Id)  nt

FROM (SELECT Id,(Ntile(160) over( ORDER BY Id)) nt FROM demo)

test

GROUP BY nt

ORDER BY nt

option (maxDOP 1024)

Oracle Sql developer error: could not install some modules

 Oracle SQL Developer Error  : 

Solutions :

Go to command prompt

C:\Users\akpandey\AppData\Roaming\SQL Developer\system22.2.1.234.1810\system_cache\config\Modules

• delete all files here 
• restart the SQLDeveloper .

This solution work in my case all connection all there . 

DMS mapping JSON ( one schema (DB1) to other schema (DB2)) - AWS

 DMS mapping task JSON - AWS 

{

    "rules": [

        {

            "rule-type": "transformation",

            "rule-id": "828748134",

            "rule-name": "828748134",

            "rule-target": "schema",

            "object-locator": {

                "schema-name": "dbo"

            },

            "parallel-load": null,

            "rule-action": "rename",

            "value": "pra_mns_pss",

            "old-value": null

        },

        {

            "rule-type": "transformation",

            "rule-id": "828155163",

            "rule-name": "828155163",

            "rule-target": "table",

            "object-locator": {

                "schema-name": "dbo",

                "table-name": "demo2"

            },

            "parallel-load": null,

            "rule-action": "rename",

            "value": "demo2",

            "old-value": null

        },

        {

            "rule-type": "selection",

            "rule-id": "828120150",

            "rule-name": "828120150",

            "object-locator": {

                "schema-name": "dbo",

                "table-name": "demo2"

            },

            "rule-action": "include",

            "filters": [],

            "parallel-load": null,

            "isAutoSegmentationChecked": false

        },

        {

            "rule-type": "selection",

            "rule-id": "820918688",

            "rule-name": "820918688",

            "object-locator": {

                "schema-name": "dbo",

                "table-name": "demo1"

            },

            "rule-action": "include",

            "filters": [],

            "parallel-load": null,

            "isAutoSegmentationChecked": false

        },

        {

            "rule-type": "transformation",

            "rule-id": "1",

            "rule-name": "1",

            "rule-target": "table",

            "object-locator": {

                "schema-name": "dbo",

                "table-name": "demo1"

            },

            "rule-action": "rename",

            "value": "demo1",

            "old-value": null

        }

    ]

}

How to check all node are serving in RAC - 4 node cluster

 

Query to check , all node are serving connection in RAC

Query-1

select inst_id,count(*)
from
   gv$session
where
   username is not null
group by
   inst_id;

Query-2

select
   inst_id,
   count(*)
from
   gv$session
where
   status='ACTIVE' and username is not null
group by
   inst_id;