ETL Freeze
- Cortlandt _
The Freeze feature protects/locks out data warehouse tables from accidental changes to the data in the target (data warehouse) table. Useful for static tables or tables with historical data that should never be overwritten.
Select Freeze to prevent all changes in ETL+ related to this target table.
When selected the Freeze checkbox doesn't allow any action on the target table. It reezes the (target) table (in the data warehouse). A job on the ETL+ Job Page can includes a frozen target table but log file will record any action on the table with the words “Skip. This table is frozen."
On the ETL+ Extract, Transform and Load (ETL) Page selecting Freeze on a target table will inactivate the Load All button, the Extract SQL Statement panel, the Design page, and the target table name on the Target Object panel.
Â
More Advanced Options for Protecting Data in SQL Server
For more advanced users with SQL Server administration capabilities who want to provide a higher level of protection to unchanging, static, or archived historical data.
To provide a higher level of protection make the table Read Only. For instance see How to make a table Read Only in SQL Server?
Â