In the scenario outlined in #18 and given that the output table(s) will be accessed by concurrent readers describe how your SQL code would be structured to minimize lock contention.

Question:In the scenario outlined in #18 and given that the output table(s) will be accessed by concurrent readers describe how your SQL code would be structured to minimize lock contention.?

Answer:

Tags:Interview Questions, Data Warehouse, Abinitio,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Hotel Management System Software

Hotel Management System software is a web based system help to manage reservations, roomstays, bookings, guests, folios, invoices and billing etc. The software features include revenue management, booking calendar, guest relationship management, check-in & check-out, invoices and receipts etc...