CODEWITHSUNDEEP
amazon-web-servicesaws-dms
Megha
Megha

Reputation: 19

Is there a way to skip one row during Data migration from Oracle to Redshift

I am working on Data migration from Oracle to Redshift and want to apply the transformation rule to skip one row. I know we can use remove column but not row. Anyone can give me any suggestions if I can there is a way to skip a row?

Upvotes: 0

Views: 486

Answers (1)

Sudarshan kumar
Sudarshan kumar

Reputation: 1585

There is no direct inbuilt way to skip row from using DMS . There is one thing that you can do is filter operation on column . If you have a column where you can define range i.e integer column in source data table. Oracle has one N tile query that will sort table in order . Once you have range defined then you can split your DMS task based on ranges and skip the row that you want .

DMS Source Filter

Sample example for skipping row 3 here

{
                          "rule-type": "table-settings",
                          "rule-id": "4",
                          "rule-name": "4",
                          "object-locator": {
                            "schema-name": "abc",
                            "table-name": "table1"
                          },
                          "parallel-load": {
                            "type": "ranges",
                            "columns": [
                              "ID"
                            ],
                            "boundaries": [
                              [
                                "Row1"
                              ],
                              [
                                "Ro2"
                              ],
                              [
                                "Row4"
                              ],
                              [
                                "Ro5"
                              ]
                            ]
                          }
                        }
                      ]
                    }

Upvotes: 1

Related Questions