Filter

A conditional statement or process that includes or excludes eliminates data based on its value. Typically seen as a SQL "where" clause.

Full Population Update

Performing a complete load of the data warehouse irrespective of when it was last updated. This process is usually used for initial data warehouse seeding (or initialization), or a complete snapshot of a particular table that has no cyclical processing, rather than only the changed data.