Description

The OraclePartitionReceiver creates one or more ControlFile descriptions and one or more inFiles containing the generated data.


This Receiver is meant to be used in Scenarios that are run by the GenRocket GPartition engine to generate huge amounts of data; thus, this parameter will automatically be set by the GPartition engine.


Note: To learn more about the GenRocket GPartition engine, click here. 


Parameters

The following parameters can be defined for the OraclePartitionReceiver. Items with an asterisk (*) are required. 

  • outputPath* - Defines the path where the controlFile descriptions and data files will be created. 
  • outputSubDir - Defines an optional subdirectory under the outputPath where generated data will be stored. 
  • resourcePath* - Defines the path where the resource file for JDBC connection properties exists.
  • resourceSubDir - Defines an optional subdirectory under the resourcePath where the resource file for JDBC connection properties exists.
  • resourceName* -  Defines the name of the resource that contains the database connection information on a user's local machine.
  • tableName* - Defines the name of the database table that will be loaded via one or more inFiles.
  • fieldTerminator* - Defines how each data field within the controlFile data file will be terminated. 
  • filesPerDirectory* - Defines the number of files that will be created in each directory.
  • lineTerminator* - Defines how each data row within the controlFile data file will be terminated. 
  • recordsPerFile* - Defines the number of records that will be stored in each file. 
  • executeControlFile* - Defines whether each controlFile should be executed after all inFiles have been generated. 
  • sqlLoaderPath - Defines the path to where the SQL Load for Oracle is located. 
  • generateBadFile* - Defines whether to create the bad file or not. The bad file contains records that were rejected, either by SQL *Loader or by the Oracle database. 
  • serverNumber* - Defines the server instance number where the Receiver will be running and helps the Receiver determine the output directory structure where it will deposit the generated data files. This Receiver is meant to be used in Scenarios that are run by the GenRocket GPartition Engine to generate huge amounts of data; thus, this parameter will automatically be set by the GPartition engine.
  • instanceNumber* - Defines the runtime instance number on a given server instance where the Receiver will be running and helps the Receiver determine the output directory structure where it will deposit the generated data files. This Receiver is meant to be used in Scenarios that are run by the GenRocket GPartition Engine to generate huge amounts of data; thus, this parameter will automatically be set by the GPartition engine.
  • foreignKeyCheck* - Defines whether to ignore the foreign key check while populated data.


Receiver Attributes Property

The Receiver defines two property keys that can be modified on any of its associated Domain Attributes:

  • columnName - Specifies the table column name as it is in the actual database (e.g., first_name, last_name).
  • include - Determines if the Attribute will be included in the controlFile data dump.