Does the selection of Clear the table and Insert rows in the ODBC stage send a Truncate statement to the DB or does it do some kind of Delete logic.Â

Question:Does the selection of Clear the table and Insert rows in the ODBC stage send a Truncate statement to the DB or does it do some kind of Delete logic. ?

Answer: There is no TRUNCATE on ODBC stages. It is Clear table blah blah and that is a delete from statement. On an OCI stage such as Oracle, you do have both Clear and Truncate options. They are radically different in permissions (Truncate requires you to have alter table permissions where Delete doesn't).  

Tags:Interview Questions, Data Warehouse, DataStage,

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

SMS Management System Software

This software used to Send bulk SMS (short text messages) from your computer and assists you to rapidly connect with your customers and staff, communicate with them easily and cheaply, using latest technology that help to generate bulk SMS on just one click to all the database....