June 26, 2020 at 5:24 pm
We have a database is quite large and we will like to filter the rows replicated from a particular table to specific rows that meet a certain criteria
can this kind of filtering be done
Rgards
Atulyan
June 26, 2020 at 7:46 pm
Just so I understand things right, you are asking if you can filter the rows from table A that are replicated based on specific criteria? if so, this is entirely possible; but you need some way to uniquely identify the rows such as putting a row number on the end grouped by or partitioned by one or more columns (all of the columns that mark it as a "duplicate") and then filter where the row number is greater than 1.
If this is not what you are looking for, could you provide some sample data explaining what you are looking for?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply