Does Vertica has an already existing tool for Validation of migrated data from TeraData to HP Verti
+1Does Vertica has an already existing tool for Validation of migrated data from TeraData to HP Vertica ?? If I am migrating data from Teradata to Vertica do I have the Data validation featute provide by Vertica ???
+2Hi Syed, we're looking in to this! I have asked the product team your team your question and if it is not yet a feature, please feel free to suggest it in the "ideas" section of our community.
Hi, Thank you for the questions. Please follow the link below to for details on checking data format before and after loading. https://my.vertica.com/docs/6.1.x/HTML/index.htm#17473.htm Regards, Bhawana
+2Hi Syed, The best way to validate the data is typically to run queries against both systems that contain simple counts or aggregates and compare results between the two. Regards, Alison
+1Is there any automated tool for doing this ????
We have a tool known as iCEDQ which is used for migration testing. It will solve your problem Syed. Actually currently i am writing a white paper on how to test using iCEDQ when migrating to vertica.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
