Creating a Metadata File
If the file has an .mdd extension, the system expects a set of Column attribute values, optionally preceded by a row identifying the delimiter and a row defining Table attribute values, each of which must begin with a key word. A row beginning with dashes is treated as a comment. For example:
--This is a comment.
Example 7-1 Text Load Set Metadata File
lsh_delimiter = , --This section is for the Table attributes lsh_table= DM,DEMOG Table,EMP,EMP,EMP,Staging with Audit,Yes,Yes,Blinded,target,yes,yes --The following are columnsComment Line 2 INITS,VARCHAR2,100,,inits,inits,2.,,inits,no,1 AGE,NUMBER,10,,2,age,age,2.,,age,yes,1 DOB,DATE,,,3,dob,dob,datetime.,,dob,yes,1,MM/DD/YY HH24:MI:SS
Parent topic: Text Load Set Table Descriptors