| |
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). |
| May 05, 2008 01:56:04 |
#1 |
| sankarganeshvel |
Database Expert Member Since: May 2008 Total Comments: 4 |
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 just clear the data in the table when each new loop it encounters .it wont send any commands to the database |
| |
Back To Question | |
