Answer / abinash

yes we can have nested transaction.

A transaction is nothing a set of sql statement which either executes at a time or nothing will happen and we specify the transaction using Begin and End.

And also we can have multiple begin end (nested transaction) inside a transaction.

fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

---

How to use online Backups?

0 Answers  

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

0 Answers   IBM,

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

---

what is difference between primary key and unique key ?

2 Answers  

---

What are the main phases of database development?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

---

How would you design a database for an online site, which would average a million hits a day?

0 Answers  

---

How long can an error message be in raiseerror function?

0 Answers  

---

what is Normalization?

6 Answers   TCS,

---

State the acid rules?

0 Answers  

---