In SAP BW, data transformation occurs at three points: Transfer Rules (initial load), Transfer Routine (record-level logic during transfer), and Update Rules (when updating to target cubes/ODS). Extract Rules are for data extraction, not transformation.