Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
- Last Active
- Administrator, Moderator, Vertica Employee, Member, VerticaExpert, Technical Solutions Expert
- User Role
- Vertica Employee
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
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