AGS S2 E2 HD - External Tables / Space Optimization / Data Masking


• External tables can be created and edited using a graphical editor.
• Space Optimization feature allows Compress, Repack, Shrink and De-Fragment of tables or indexes for IDS 11.50.FC4+.
• Data Masking can obscure sensitive data for non-production environments. Masked data can either be exported to text files, or data can be updated in place after cloning the database. Methods provided include random substitution, lookup from database objects and files, shuffling, number and date variance.
• Enhanced character encoding support for LOAD/UNLOAD SQL commands and Data Import/Export wizards (including Data Masking).

Go back to videos