What
is the difference between a Bulk and Normal load and where exactly is it
defined?
Bulk load is used to load records in bulk to enhance performance. It bypasses all the database level logging. It can only be used when no index is defined on the table. It is a file level operation. The records are directly written at the data files. Normal load is a regular insert we know about. With logging, with indexes, slower and can be rolled back. In Informatica it is defined at the session level.
Bulk load is used to load records in bulk to enhance performance. It bypasses all the database level logging. It can only be used when no index is defined on the table. It is a file level operation. The records are directly written at the data files. Normal load is a regular insert we know about. With logging, with indexes, slower and can be rolled back. In Informatica it is defined at the session level.
No comments:
Post a Comment