Ab Initio Data Warehousing Question:
Download Questions PDF

Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database)?

Answer:

Take an entire database backup and restore it in different instance.

Take a statistics of all valid and invalid objects and match.

Periodically refresh

Download Ab Initio Interview Questions And Answers PDF

Previous QuestionNext Question
How can i run the 2 GUI merge files?How would you find out whether a SQL query is using the indices you expect?