skamat
Administrator
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
skamat Administrator
Reactions
-
Re: vertica constraint enforcement and deduplication
You can automate process to run constraint validation and delete duplicate records. I would not initiate purge on a table or on a specific partition in a table unless you have at least 5% deleted rec… (View Post)1 -
Re: vertica constraint enforcement and deduplication
There are many option to prevent loading duplicate records: * Copy into staging table and then merge into fact * Copy into fact but use "no commit" option for copy and then run check_constr… (View Post)1