Skip navigation links

Oracle® OLAP Java API Reference
11g Release 2 (11.2)

E10794-05


oracle.olapi.syntax
Class LoadCommand

java.lang.Object
  extended by oracle.olapi.syntax.SyntaxObject
      extended by oracle.olapi.syntax.BuildCommand
          extended by oracle.olapi.syntax.SimpleCommand
              extended by oracle.olapi.syntax.LoadCommand


public final class LoadCommand
extends SimpleCommand

A SimpleCommand that loads data into the dimensions or measures of an analytic workspace from relational source tables during a build. Options to a load command affect the loading of the data. You get an instance of a LoadCommand with an associated option by using one of static fields of this class or by using a constructor method.

The following table lists the load command options and describes them.

Load Option Effect on Load
DEFAULT For an MdmPrimaryDimension, the default option is a synchronized load.

For an MdmCube, the default option is an unsynchronized load.

SYNCH For an MdmPrimaryDimension, adds new members to the dimension and removes members that no longer exist in the relational source tables.

For an MdmCube, the SYNCH and NO_SYNCH options have the same effect. To avoid confusion, use the NO_SYNCH option for an MdmCube.

NO_SYNCH For an MdmPrimaryDimension, adds new members but does not remove members that no longer exist in the relational source tables.

For an MdmCube, loads the measure data for new dimension members but does not delete the data for dimension members that no longer exist. To remove the measure data for nonexistent dimension members, add a ClearCommand in the BuildSpecification before the LoadCommand. If you specify this option for an MdmCube, the build process determines whether to use a serial build or a parallel build.

SERIAL For an MdmCube, loads the data into the measures using a single process. If a measure is partitioned, then this option loads the data of the partitions serially. If the partitioning of the cube does not match the partitioning of the source table, then a serial load is a good choice.

For an MdmPrimaryDimension, this option does not apply.

PARALLEL For an MdmCube, loads the data for partitioned measures using parallel processes. This option loads the data into the measures of the partitions simultaneously, using one process for each partition, or as many processes as are available.

For an MdmPrimaryDimension, this option does not apply.

PRUNE For an MdmCube with partitioned measures, spawns jobs only for the partitions for which measure data exists. Determining which partitions have data requires scanning the entire table. For tables that have terrabytes of data, a full table scan can be time comsuming.

For an MdmPrimaryDimension, this option does not apply.

For more information about partitioned cubes, see the setPartitionLevel method of AWCubeOrganization, the setParallelism method of BuildProperties, and Oracle OLAP User's Guide.


Field Summary
static LoadCommand DEFAULT
          Produces a LoadCommand that executes a default load.
static java.lang.String DEFAULT_OPTION
          A constant that represents a default load.
static LoadCommand NO_SYNCH
          Produces a LoadCommand that has the NO_SYNCH option.
static java.lang.String NO_SYNCH_OPTION
          A constant that represents an unsynchronized load.
static LoadCommand PARALLEL
          Produces a LoadCommand that has the PARALLEL option.
static java.lang.String PARALLEL_OPTION
          A constant that represents a parallel load.
static LoadCommand PRUNE
          Produces a LoadCommand that has the PRUNE option.
static java.lang.String PRUNE_OPTION
          A constant that represents a pruned load.
static LoadCommand SERIAL
          Produces a LoadCommand that has the SERIAL option.
static java.lang.String SERIAL_OPTION
          A constant that represents a serial load.
static LoadCommand SYNCH
          Produces a LoadCommand that has the SYNCH option.
static java.lang.String SYNCH_OPTION
          A constant that represents a synchronized load.

 

Constructor Summary
LoadCommand()
          Creates a LoadCommand with the default load command option.
LoadCommand(java.lang.String option)
          Creates a LoadCommand with the specified load command option.
LoadCommand(java.lang.String option, Condition whereCondition)
          Creates a LoadCommand with the specified load command option and an associated where Condition.
LoadCommand(java.lang.String option, Condition whereCondition, java.lang.String cubeMapName)
          Creates a LoadCommand with the specified load command option and an associated where Condition.
LoadCommand(java.lang.String option, java.lang.String cubeMapName)
          Creates a LoadCommand with the specified load command option and an associated CubeMap.

 

Method Summary
 java.lang.String getCubeMapName()
          Gets the name of the CubeMap that is associated with this LoadCommand.
 java.lang.String getLoadOption()
          Gets the load command option of this LoadCommand.
 Condition getWhereCondition()
          Gets the Condition that will be applied to the base table during this load.
 java.lang.Object visit(SyntaxObjectVisitor visitor, java.lang.Object context)
          Calls the visitLoadCommand method of the SyntaxObjectVisitor and passes that method this LoadCommand and an Object.

 

Methods inherited from class oracle.olapi.syntax.SyntaxObject
equals, equals, fromSyntax, fromSyntax, fromSyntax, fromSyntax, fromSyntax, isValid, toSyntax, toSyntax, toSyntax, toSyntax, toSyntax, toSyntax

 

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Field Detail

DEFAULT_OPTION

public static final java.lang.String DEFAULT_OPTION
A constant that represents a default load.
See Also:
Constant Field Values

SYNCH_OPTION

public static final java.lang.String SYNCH_OPTION
A constant that represents a synchronized load.
See Also:
Constant Field Values

NO_SYNCH_OPTION

public static final java.lang.String NO_SYNCH_OPTION
A constant that represents an unsynchronized load.
See Also:
Constant Field Values

PRUNE_OPTION

public static final java.lang.String PRUNE_OPTION
A constant that represents a pruned load.
See Also:
Constant Field Values

SERIAL_OPTION

public static final java.lang.String SERIAL_OPTION
A constant that represents a serial load.
See Also:
Constant Field Values

PARALLEL_OPTION

public static final java.lang.String PARALLEL_OPTION
A constant that represents a parallel load.
See Also:
Constant Field Values

DEFAULT

public static final LoadCommand DEFAULT
Produces a LoadCommand that executes a default load.

SYNCH

public static final LoadCommand SYNCH
Produces a LoadCommand that has the SYNCH option.

SERIAL

public static final LoadCommand SERIAL
Produces a LoadCommand that has the SERIAL option.

PARALLEL

public static final LoadCommand PARALLEL
Produces a LoadCommand that has the PARALLEL option.

NO_SYNCH

public static final LoadCommand NO_SYNCH
Produces a LoadCommand that has the NO_SYNCH option.

PRUNE

public static final LoadCommand PRUNE
Produces a LoadCommand that has the PRUNE option.

Constructor Detail

LoadCommand

public LoadCommand()
Creates a LoadCommand with the default load command option.

LoadCommand

public LoadCommand(java.lang.String option)
Creates a LoadCommand with the specified load command option.
Parameters:
option - A String that contains a load command option.

LoadCommand

public LoadCommand(java.lang.String option,
                   Condition whereCondition)
Creates a LoadCommand with the specified load command option and an associated where Condition.
Parameters:
option - A String that contains a load command option.
whereCondition - A Condition that will be applied to the base table for this load.

LoadCommand

public LoadCommand(java.lang.String option,
                   Condition whereCondition,
                   java.lang.String cubeMapName)
Creates a LoadCommand with the specified load command option and an associated where Condition.
Parameters:
option - A String that contains a load command option.
whereCondition - A Condition that will be applied to the base table for this load.
cubeMapName - A String that contains the name of a CubeMap to use when loading the measure data for an MdmCube.

LoadCommand

public LoadCommand(java.lang.String option,
                   java.lang.String cubeMapName)
Creates a LoadCommand with the specified load command option and an associated CubeMap.
Parameters:
option - A String that contains a load command option.
cubeMapName - A String that contains the name of a CubeMap to use when loading the measure data for an MdmCube.

Method Detail

visit

public java.lang.Object visit(SyntaxObjectVisitor visitor,
                              java.lang.Object context)
Calls the visitLoadCommand method of the SyntaxObjectVisitor and passes that method this LoadCommand and an Object.
Specified by:
visit in class SyntaxObject
Parameters:
visitor - A SyntaxObjectVisitor.
context - An Object.
Returns:
The Object returned by the visitLoadCommand method.

getCubeMapName

public java.lang.String getCubeMapName()
Gets the name of the CubeMap that is associated with this LoadCommand.
Returns:
A String that contains the name of the CubeMap associated with this LoadCommand.

getLoadOption

public java.lang.String getLoadOption()
Gets the load command option of this LoadCommand. For the default option, this method returns an empty string.
Returns:
A String that contains the load command option of this LoadCommand.

getWhereCondition

public Condition getWhereCondition()
Gets the Condition that will be applied to the base table during this load.
Returns:
A CONDITION that will be applied during execution of this LoadCommand.

Skip navigation links

Copyright © 2002, 2010, Oracle. All rights reserved.