Navigation:  Port to SQL > Step ONE (Dictionary parsing) > Select Settings Level > Advanced settings 1/5

Predefined DEFAULT level using ADVANCED [1/5] settings

 

 

DETECT Date and Time Columns : create a STRING and GROUP (OVER the String) and DATE and TIME Columns

 

DETECT and GROUP Date and Time individual Columns (ie : "OrderedDate" and "OrderedTime") in a single DateTime

 

DEFINE the (generally used) Column NAMES for DATE and TIME Columns (searched for in GROUPINGS)

DEFINE the PREFIX and SEPARATOR to use for PREFIXING : "sql" and "_"

 

All DCT and SQL scripts will use lowercase

 

 

This STEP allows you to DEFINE all these settings which will be used

 

 

 

NOTE : If you check the "Log all extracted Infos (DCTX and TXA to HD)" box then DMC will generate for you all the Tables parsed in TPS format (originals) and you can find them in your folder at the end of DCTX parsing process - this can be handy at some times.

---