When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
643Describe 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)?
646
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What is the syntax for m_dump in abinitio?
What is MAX CORE of a component?
What are the differences between informatica and abinitio?
How to compare two dmls in abinitio
What are differences between different versions of co-op?
Explain the ab initio etl tool in high level?
What are the six data process products of ab initio (architecture of ab initio)?
How is the partitioning with key different from round robin partition?
You can ask about different vector functions. How to use in abinitio graph?
What is data encoding?
What is the importance of eme in abinitio?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
Code check-in and check-out commands in AbInitio
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?