Even though creating and dropping views in #Teradata is a bit expensive, they are mandatory when trying to do UPDATE in #PowerCenter - otherwise following error is displayed: Full pushdown optimization stops at the target because update on Teradata requires a view, and view creation is not enabled. #ETL #tip