When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
1140Describe 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)?
1152
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What information is provided by .dbc file extension for connecting to the database?
Explain how you can run a graph infinitely in ab initio?
What are the differences between informatica and abinitio?
Can you explain data flow graph with an example?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What is air-project parameter ?
What do you understand by a cartesian join?
Mention some file extensions which are used in abinitio?
What are the different types of parallelism in ab initio?
What are the different types of parallelism used in abinitio?
How do you truncate a table?
Explain how abinitio eme is segregated?
What do you mean by a transaction file and how it is different from that of a sort file?
What are the functions of the replicate and dedup component?