Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E1440601 


createDataProfileCommand = OMBCREATE ( DATA_PROFILE "QUOTED_STRING" [ SET ( "setPropertiesClause" [ SET "setReferenceClause" ]  "setReferenceClause" ) ] { ADD ( TABLE  VIEW  EXTERNAL_TABLE  MATERIALIZED_VIEW  DIMENSION  CUBE  FLAT_FILE ) "QUOTED_STRING" [ USING ATTRIBUTE_SET "QUOTED_STRING" ] [ LIMIT_COLUMNS ] } ) setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" setReferenceClause = ( "setReferenceLocationClause" [ SET "setReferenceIconSetClause" ]  "setReferenceIconSetClause" ) propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } setReferenceLocationClause = ( REFERENCE  REF ) LOCATION "QUOTED_STRING" setReferenceIconSetClause = ( REFERENCE  REF ) ICONSET "QUOTED_STRING" propertyValue = ( "QUOTED_STRING"  "INTEGER_LITERAL"  "FLOATING_POINT_LITERAL" )
Configuration properties for DATA_PROFILE that affect loading:
Name: COPY_DATA
Type: BOOLEAN
Valid Values: true  false
Default: true
Setting this to true will enable copying of data from source to profile workspace.
Name: FORCE_COPY_DATA
Type: BOOLEAN
Valid Values: true  false
Default: false
Setting this to true will allways force a profile to run.
Name: CALCULATE_DATATYPES
Type: BOOLEAN
Valid Values: true  false
Default: false
Setting this to true will enable data type discovery for the selected table.
Name: CALCULATE_COMMON_FORMATS
Type: BOOLEAN
Valid Values: true  false
Default: false
This tells the profiler if common formats are to be discovered for all sources in this profile.
Name: NULL_VALUE
Type: STRING
Valid Values: any string value
Default: null
This value will be considered as the null value when profiling. Please enclose the value in single quotes. An unqouted null (the current default value) will be considered a database null.
Name: SAMPLE_RATE
Type: NUMBER
Valid Values: 1100
Default: 100
This value will be the percent of total rows that will be randomly selected during loading.
Configuration properties for DATA_PROFILE that affect profiling:
Name: CALCULATE_DOMAINS
Type: BOOLEAN
Valid Values: true  false
Default: true
Setting this to true will enable domain discovery.
Name: DOMAIN_MAX_COUNT
Type: NUMBER
Valid Values: 1any number
Default: true
The maximum number of distinct values in a column in order for that column to be discovered as possibly being defined by a domain. Domain Discovery of a column occurs if the number of distinct values in that column is at or below the Max Distinct Values Count property, AND, the number of distinct values as a percentage of total rows is at or below the Max Distinct Values Percent property.
Name: DOMAIN_MAX_PERCENT
Type: NUMBER
Valid Values: 1100
Default: true
The maximum number of distinct values in a column, expressed as a percentage of the total number of rows in the table, in order for that column to be discovered as possibly being defined by a domain. Domain Discovery of a column occurs if the number of distinct values in that column is at or below the Max Distinct Values Count property, AND, the number of distinct values as a percentage of total rows is at or below the Max Distinct Values Percent property.
Name: DOMAIN_MIN_COUNT
Type: NUMBER
Valid Values: 1any number
Default: true
The minimum number of rows for the given distinct value in order for that distinct value to be considered as compliant with the domain. Domain Value Compliance for a value occurs if the number of rows with that value is at or above the Min Rows Count property, AND, the number of rows with that value as a percentage of total rows is at or above the Min Rows Percent property.
Name: DOMAIN_MIN_PERCENT
Type: NUMBER
Valid Values: 1100
Default: true
The minimum number of rows, expressed as a percentage of the total number of rows, for the given distinct value in order for that distinct value to be considered as compliant with the domain. Domain Value Compliance for a value occurs if the number of rows with that value is at or above the Min Rows Count property, AND, the number of rows with that value as a percentage of total rows is at or above the Min Rows Percent property.
Name: CALCULATE_UK
Type: BOOLEAN
Valid Values: true  false
Default: true
Setting this to true will enable unique key discovery.
Name: UK_MIN_PERCENT
Type: NUMBER
Valid Values: 1100
Default: 75
This is the minimum percentage of rows that need to satisfy a unique key relationship.
Name: CALCULATE_FD
Type: BOOLEAN
Valid Values: true  false
Default: true
Setting this to true will enable functional dependency discovery.
Name: FD_MIN_PERCENT
Type: NUMBER
Valid Values: 1100
Default: 75
This is the minimum percentage of rows that need to satisfy a functional dependency relationship.
Name: FD_UK_LHS_COUNT
Type: NUMBER
Valid Values: 1number of attributes of source less 1
Default: 1
This is the maximum number of attributes for unique key and functional dependency profiling.
Name: CALCULATE_FK
Type: BOOLEAN
Valid Values: true  false
Default: true
Setting this to true will enable foreign key discovery.
Name: FK_MIN_PERCENT
Type: NUMBER
Valid Values: 1100
Default: 75
This is the minimum percentage of rows that need to satisfy a foreign key relationship.
Name: CALCULATE_REDUNDANT_COLUMNS
Type: BOOLEAN
Valid Values: true  false
Default: false
Setting this to true will enable redundant column discovery with respect to a foreign keyunique key pair.
Name: REDUNDANT_MIN_PERCENT
Type: NUMBER
Valid Values: 1100
Default: 75
This is the minimum percentage of rows that are redundant.
Name: CALCULATE_DATA_RULES
Type: BOOLEAN
Valid Values: true  false
Default: false
Setting this to true will enable data rule profiling for the selected table.
Name: CALCULATE_PATTERNS
Type: BOOLEAN
Valid Values: true  false
Default: false
Setting this to true will enable pattern discovery.
Name: MAX_NUM_PATTERNS
Type: NUMBER
Valid Values: any number less than the number of rows of the source
Default: 10
This tells the profiler to get the topN patterns for the attribute.