When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
No Answer is Posted For this Question
Be the First to Post Answer
Mention what is rollup component?
Mention some ways for improving performance of a graph?
Describe the effect of the "checkpoint" t-sql statement?
what is difference between fuse and join? Explain in detail? In which scenario we will use them?
What is difference between API
2 Answers CitiGroup, IBM, TCL,
Explain the ab initio etl tool in high level?
Can anyone give me an example of realtime start script in the graph?
what is the difference between i)public ii)private iii)common and client projects?
What are the types of data processing you are familiar with?
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)?
Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use
How would you find out whether a sql query is using the indices you expect?