Examining advanced Table File Wizard options
The Table Files Wizard is used by many to load a file and generate the load script for it. However, there is a not-so-secret secret button with the word Next written on it that is often ignored:
There are some great things in here that are worth looking at.
Enabling a transformation step
When we first hit that Next button on the wizard, we are presented with the interesting option, Enable Transformation Step:
If we click on this button, it brings us to a new dialog with several tabs:
The Garbage tab ...