Difference between OLTP and OLAP

OLTP

Current data
Short database transactions
Online update/insert/delete
Normalization is promoted
High volume transactions
Transaction recovery is necessary


OLAP
Current and historical data
Long database transactions
Batch update/insert/delete
Denormalization is promoted
Low volume transactions
Transaction recovery is not necessary

Constraint Based Loading

http://www.geekinterview.com/question_details/30013

Chapter 3

 Search for Deltas
Use of Minus
Audit Columns
XML DTD
Hint for performance