1.

Explain The Steps To Update A Multi-table Dw In Pb?

Answer»

The FOLLOWING steps are involved in the process:

  • Use. modify/.object NOTATION to MAKE ONE table updateable
  • SET the primary keys for the table
  • Perform DW_1 update with FALSE argument for the reset option in the Update() FUNCTION
  • After © is successful, make 2nd table updateable and 1st table not updateable
  • Next call update() with TRUE argument for the the reset option in the Update() function
  • COMMIT/ROLLBACK depending on success or failure.

The following steps are involved in the process:


Discussion

No Comment Found

Related InterviewSolutions