|
INTERVIEW QUESTIONS
DATA WAREHOUSING
ABINITIO
DETAILS
Question: When running a stored procedure definition script how would you guarantee the definition could be "rolled back" in the event of problems.
Answer: There are quite a few factors that determines the approach such as what type of version control are used, what is the size of the change, what is the impact of the change, is it a new procedure or replacing an existing and so on.
If it is a new, then just drop the wrong one
if it is a replacement then how big is the change and what will be the possible impact, depending upon you can have the entire database backed up or just create a script for your original procedure before messing it up or you just do an ed and change the file back to original and reapply. you may rename the old procedure as old and then work on new and so on.
few issues to keep in mind are synonyms, dependancies, grants, any job calling the procedure at the time of change and so on. In nutshell, scenario can be varied and solution also can be varied.
|
|
|
Category |
Abinitio Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7402 users |
Added on |
7/25/2011 |
Views |
71929 |
Rate it! |
|
|
Question:
When running a stored procedure definition script how would you guarantee the definition could be "rolled back" in the event of problems.
Answer:
There are quite a few factors that determines the approach such as what type of version control are used, what is the size of the change, what is the impact of the change, is it a new procedure or replacing an existing and so on.
If it is a new, then just drop the wrong one
if it is a replacement then how big is the change and what will be the possible impact, depending upon you can have the entire database backed up or just create a script for your original procedure before messing it up or you just do an ed and change the file back to original and reapply. you may rename the old procedure as old and then work on new and so on.
few issues to keep in mind are synonyms, dependancies, grants, any job calling the procedure at the time of change and so on. In nutshell, scenario can be varied and solution also can be varied. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Explain the difference between the “truncate” and "delete" commands.
|
- Abinitio Interview Questions & Answers">
View Answer
|
|
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data.
|
View Answer
|
|
Describe the elements you would review to ensure multiple scheduled "batch" jobs do not "collide" with each other.
|
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
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Abinitio Interview Questions & Answers - Exam Mode /
Learning Mode
|