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

Links

vhttp://www.sql-server-performance.com/

SQL Server IQ Links

http://vyaskn.tripod.com/iq.htm

Informatica IQ Links

Techtiks 

http://informatica.techtiks.com/informatica_questions.html

Informatica Random

The Integration Service ensures that the target database code page is a superset of the source database code page.