Keywords integrated: Informatica PowerCenter 106, dynamic lookup, pushdown optimization, workflow variables, SCD Type 2, session partitioning.