1. Application Developer's Guide
  2. Defining Data Marts
  3. Defining Different Types of Data Marts
  4. Defining Text Data Marts
  5. Text Data Mart Parameters

Text Data Mart Parameters

Oracle LSH automatically creates Parameters for Text-type Data Marts. For information on how you can modify them, see Setting Data Mart Parameter Values.

Note:

Because these are predefined, required Parameters you should change only the default value, Read Only setting, or Prompt for each Parameter or the Data Mart may not function properly; see Setting Data Mart Parameter Values.

  • Zip Result Flag: Select one of the following values as the default:

    • No. If set to No, the system does not generate a zipped file. The Data Mart output consists of one text file for each Table Descriptor and the log file. The system disregards the defined Export Filename.

    • Zip. If set to Zip, the system generates a single zipped file that includes the text files generated for each Table Descriptor and the log file.

    • Both. If set to Both, the system generates a text file for each Table Descriptor, creates a zipped file that contains all the text files and the log file, and also leaves a copy of each text file and the log file outside the zipped file.

    The default value is Zip.

  • FirstRow Desc: If you are creating a fixed-format Text Data Mart, you must enter a value for this Parameter, which determines the way the Data Mart handles the first row for each Table Descriptor.

    • Yes. If set to Yes, the system inserts the Column names as the first row in the text file for each Table Descriptor. If the Column name is too long for its length, the system truncates it. If it is a different format (for example, a Column name in text for a data type Number Column), the system inserts a warning in the Data Mart log file.

    • No. If set to No, the system starts the file with the data of the first record, not the Column names.

    The system ignores this value for delimited text Data Marts.

  • Operating System: Select your operating system: UNIX or MS Windows. The system inserts the appropriate carriage return for the operating system at the end of every record. If you are using Linux, select UNIX. The default value is UNIX.

Parent topic: Defining Text Data Marts