|
Related Questions |
View Answer |
|
When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why.
|
View Answer
|
|
How can you force the optimizer to use a particular index?
|
View Answer
|
|
How would you find out whether a SQL query is using the indices you expect?
|
View Answer
|
|
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
|
View Answer
|
|
Why might you create a stored procedure with the 'with recompile' option?
|
View Answer
|
|
What is the purpose of having stored procedures in a database?
|
View Answer
|
|
What are Cartesian joins?
|
View Answer
|
|
What is an outer join?
|
View Answer
|
|
What are primary keys and foreign keys?
|
View Answer
|
|
Have you used rollup component? Describe how.
|
View Answer
|
|
Have you worked with packages?
|
View Answer
|
|
Explain what is lookup?
|
View Answer
|
|
How to handle if DML changes dynamically in abinitio
|
View Answer
|
|
How many components in your most complicated graph?
|
View Answer
|
|
What is the difference between look-up file and look-up, with a relevant example?
|
View Answer
|
|
Do you know what a local lookup is?
|
View Answer
|
|
How do you add default rules in transformer?
|
View Answer
|
|
How can you run a graph infinitely?
|
View Answer
|
|
What are kinds of layouts does ab initio supports
|
View Answer
|
|
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summirize group of data record. then where we will use aggregation ?
|
View Answer
|