| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
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). |
| August 08, 2009 07:28:20 |
#2 |
| sujathanaidu |
Member Since: June 2009 Total Comments: 1 |
RE: 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.
|
| It is same as DELETE from the table. |
| |
Back To Question | |
