Difference between clear before and truncate before insert
Posted: Mon Jul 02, 2007 11:28 pm
Using DataStage Server Edition, oracle OCI Stage
When selecting how to update a table there are two options I'm interested in. Clear table then insert rows and Truncate table then insert rows.
I know the difference between the delete and truncate functions, but what I would like to know is how DataStage carries out the deletion process.
Does it Delete, Insert, Commit or Delete, Commit, Insert, Commit.
Basically what I want to know is if users will be able to query data as its being updated because if I trunc then load the table there will be a small period where the table will be empty and users' will be querying.
Cheers.
When selecting how to update a table there are two options I'm interested in. Clear table then insert rows and Truncate table then insert rows.
I know the difference between the delete and truncate functions, but what I would like to know is how DataStage carries out the deletion process.
Does it Delete, Insert, Commit or Delete, Commit, Insert, Commit.
Basically what I want to know is if users will be able to query data as its being updated because if I trunc then load the table there will be a small period where the table will be empty and users' will be querying.
Cheers.