What is the difference between a utility and api in a RUN SQL component
Answer Posted / dinesh
api mode is put a lock on the table whereas Utility doesn't. is it ?
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Mention what dedup-component and replicate component does?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
What does de-partition mean in abinitio?
What are the steps to create a repository in ab initio?
Explain the ab initio etl tool in high level?
How would you find out whether a sql query is using the indices you expect?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Explain what is de-partition in abinitio?
Explain the methods to improve performance of a graph?
Explain what is sandbox?
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)?
What is the purpose of having stored procedures in a database?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What are the Types of parallelism in detail?
Have you used the rollup component? Describe how?