Data Warehouse & Business Intelligence
Lables
Abinitio
(10)
DWH Fundamentals
(13)
Informatica
(2)
Teradata
(38)
Wednesday, 11 September 2013
Why use MultiLoad DELETE (versus SQL DELETE)?
MultiLoad DELETE is faster and uses less disk disk (no Transient Journal).
MultiLoad DELETE is restart able.
If SQL DELETE is aborted, Teradata applies Transient Journal rows. SQL DELETE can be resubmitted, but starts from beginning.
2 comments:
Bigbuj
13 September 2013 at 16:15
Murali - Very Good Info
Reply
Delete
Replies
Reply
Unknown
14 September 2013 at 21:30
Thanks Sharan !
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Murali - Very Good Info
ReplyDeleteThanks Sharan !
ReplyDelete