# this is the rule file for the MDL
# header information
PRODSRCRELEASE=9.1.0.5.0
PRODTGTRELEASE=9.0.3.22.0
SRCRELEASE=9.2
TGTRELEASE=10.0
SRCMDLRELEASE=9.2
TGTMDLRELEASE=10.0
CLASSPATH=oracle.wh.repos.pdl.metadataloader.converter.versions
# no comments allowed between BEGIN_HEADER and END_HEADER
# unless you want it to appear as part of the header of your target file
# <TIMESTAMP> will be replaced with the date and time while <RELEASE> will be replaced with the old release version
BEGIN_HEADER
#!----------------------------------------------------------------------
#!
#!   	Oracle Warehouse Builder Upgrade Utility  <TIMESTAMP>
#!	Upgraded from 9.2 to 11.1
#!
#!----------------------------------------------------------------------  
END_HEADER

# actual rules
# always cache the project for writing the statistics
BASELANGUAGE,BASELANGUAGE,2,COPY,CACHE
SUPPORTEDLANGUAGE,SUPPORTEDLANGUAGE,2,COPY,CACHE
MULTILANGUAGESUPPORT,MULTILANGUAGESUPPORT,2,COPY,CACHE
BEGIN_MLSDESCRIPTION,BEGIN_MLSDESCRIPTION
END_MLSDESCRIPTION,END_MLSDESCRIPTION
METADATADEFINITION,METADATADEFINITION,4,COPY
BEGIN_DEFAULTVALUE,BEGIN_DEFAULTVALUE
END_DEFAULTVALUE,END_DEFAULTVALUE
PROJECT,PROJECT,4,COPY,CACHE
PROJECT,PROJECT,5,COPY,CACHE
LOCATION,LOCATION,9,COPY,CACHE
CONNECTOR,CONNECTOR,7,COPY,CACHE
RUNTIMEREPOSITORYCONNECTION,RUNTIMEREPOSITORYCONNECTION,11,COPY,CACHE
USERDEFINEDPROPERTY,USERDEFINEDPROPERTY,2,COPY,CACHE
TABLE,TABLE,5,COPY,CACHE
EXTERNALTABLE,EXTERNALTABLE,13,COPY,CACHE
BEGIN_DESCRIPTION,BEGIN_DESCRIPTION
END_DESCRIPTION,END_DESCRIPTION
BEGIN_ACCESSPARAMETER,BEGIN_ACCESSPARAMETER
END_ACCESSPARAMETER,END_ACCESSPARAMETER
DATAWAREHOUSE,DATAWAREHOUSE,25,COPY,CACHE
DATAWAREHOUSE,DATAWAREHOUSE,3,COPY,CACHE
ORACLEINSTALLEDMODULE,ORACLEINSTALLEDMODULE,25,COPY,CACHE
ORACLEINSTALLEDMODULE,ORACLEINSTALLEDMODULE,3,COPY,CACHE
FILEINSTALLEDMODULE,FILEINSTALLEDMODULE,20,COPY,CACHE
FILEINSTALLEDMODULE,FILEINSTALLEDMODULE,3,COPY,CACHE
SAPINSTALLEDMODULE,SAPINSTALLEDMODULE,34,COPY,CACHE
SAPINSTALLEDMODULE,SAPINSTALLEDMODULE,3,COPY,CACHE
SHAREDINSTALLEDMODULE,SHAREDINSTALLEDMODULE,3,COPY,CACHE
GATEWAYINSTALLEDMODULE,GATEWAYINSTALLEDMODULE,25,COPY,CACHE,type=0
GATEWAYINSTALLEDMODULE,GATEWAYINSTALLEDMODULE,3,COPY,CACHE,type=0
#COLLECTION,COLLECTION,3,COPY
#COLLECTIONSHORTCUT,COLLECTIONSHORTCUT,14,COPY,CACHE
VIEW,VIEW,5,COPY,CACHE
MATERIALIZEDVIEW,MATERIALIZEDVIEW,5,COPY,CACHE
BEGIN_NOTE,BEGIN_NOTE
END_NOTE,END_NOTE
BEGIN_PACKAGESPEC,BEGIN_PACKAGESPEC
END_PACKAGESPEC,END_PACKAGESPEC
BEGIN_PACKAGEBODY,BEGIN_PACKAGEBODY
END_PACKAGEBODY,END_PACKAGEBODY
BEGIN_SELECT,BEGIN_SELECT
END_SELECT,END_SELECT
SEQUENCE,SEQUENCE,5,COPY,CACHE
DIMENSION,DIMENSION,7,COPY,CACHE
DIMENSION,DIMENSION,5,COPY,CACHE
LEVEL,LEVEL,6,COPY,CACHE
COLUMN,COLUMN,16,COPY,CACHE
COLUMN,COLUMN,15,COPY,CACHE
COLUMN,COLUMN,12,COPY,CACHE
HIERARCHY,HIERARCHY,9,COPY,CACHE
LEVELRELATIONSHIP,LEVELRELATIONSHIP,8,COPY,CACHE
FACT,FACT,6,COPY,CACHE
MEASURE,MEASURE,12,COPY,CACHE
CHECKCONSTRAINT,CHECKCONSTRAINT,5,COPY,CACHE
BEGIN_CONDITION,BEGIN_CONDITION
END_CONDITION,END_CONDITION
PRIMARYKEY,PRIMARYKEY,COPY,CACHE
UNIQUEKEY,UNIQUEKEY,COPY,CACHE
FOREIGNKEY,FOREIGNKEY,COPY,CACHE
FACTFOREIGNKEY,FACTFOREIGNKEY,COPY,CACHE
FACTFOREIGNKEYCOLUMN,FACTFOREIGNKEYCOLUMN,COPY,CACHE
SEGMENTEDUNIQUEKEY,SEGMENTEDUNIQUEKEY,5,COPY,CACHE
ADVANCEDQUEUE,ADVANCEDQUEUE,6,COPY,CACHE
OBJECTTYPE,OBJECTTYPE,3,COPY,CACHE
TYPEFIELD,TYPEFIELD,9,COPY,CACHE
STANDALONEFUNCTION,STANDALONEFUNCTION,0,COPY,CACHE
STANDALONEPROCEDURE,STANDALONEROCEDURE,0,COPY,CACHE
FUNCTIONCATEGORY,FUNCTIONCATEGORY,6,COPY,CACHE
FUNCTION,FUNCTION,10,COPY,CACHE
PARAMETER,PARAMETER,9,COPY,CACHE
IMPLEMENTATION,IMPLEMENTATION,5,COPY,CACHE
BEGIN_SYNTAX,BEGIN_SYNTAX
END_SYNTAX,END_SYNTAX
BEGIN_UPDATE_WHERE,BEGIN_UPDATE_WHERE
END_UPDATE_WHERE,END_UPDATE_WHERE
BEGIN_DELETE_WHERE,BEGIN_DELETE_WHERE
END_DELETE_WHERE,END_DELETE_WHERE
NAMEDATTRIBUTESET,NAMEDATTRIBUTESET,6,COPY,CACHE
NAMEDATTRIBUTESETATTR,NAMEDATTRIBUTESETATTR,3,COPY,CACHE
CONFIGPARAM,CONFIGPARAM,5,COPY,CACHE
CHILDCONFIG,CHILDCONFIG,5,COPY,CACHE
CONFIGURABLE,CONFIGURABLE,4,COPY,CACHE
FILE,FILE,19,COPY,CACHE
RECORD,RECORD,5,COPY,CACHE
FIELD,FIELD,17,COPY,CACHE
MAPPING,MAPPING,7,COPY,CACHE
BEGIN_EXPRESSION,BEGIN_EXPRESSION
END_EXPRESSION,END_EXPRESSION
MAPPINGSTAGECOMPONENT,MAPPINGSTAGECOMPONENT,19,COPY,CACHE
MAPPINGSTAGECOMPONENTPROPERTY,MAPPINGSTAGECOMPONENTPROPERTY,4,COPY,CACHE
MAPPINGPARAMETERGROUP,MAPPINGPARAMETERGROUP,22,COPY,CACHE
MAPPINGPARAMETERGROUPPROPERTY,MAPPINGPARAMETERGROUPPROPERTY,4,COPY,CACHE
MAPPINGPARAMETER,MAPPINGPARAMETER,10,COPY,CACHE
MAPPINGPARAMETERPROPERTY,MAPPINGPARAMETERPROPERTY,4,COPY,CACHE
MAPPINGPARAMETERCONNECTION,MAPPINGPARAMETERCONNECTION,18,COPY,CACHE
MAPPINGPHYSICALPROPERTY,MAPPINGPHYSICALPROPERTY,4,COPY,CACHE
MAPPINGDISPLAYSET,MAPPINGDISPLAYSET,6,COPY,CACHE
MAPPINGDISPLAYSETPARAMETER,MAPPINGDISPLAYSETPARAMETER,3,COPY,CACHE
PHYSICALMAPPINGSTEP,PHYSICALMAPPINGSTEP,3,COPY,CACHE
PHYSICALMAPPINGSTEPPROPERTY,PHYSICALMAPPINGSTEPPROPERTY,4,COPY,CACHE
PHYSICALSTAGECOMPONENTPROPERTY,PHYSICALSTAGECOMPONENTPROPERTY,4,COPY,CACHE
BEGIN_PROPERTYVALUE,BEGIN_PROPERTYVALUE
END_PROPERTYVALUE,END_PROPERTYVALUE
PROCESSMODULE,PROCESSMODULE,17,COPY,CACHE
PROCESSPACKAGE,PROCESSPACKAGE,3,COPY,CACHE
PROCESS,PROCESS,5,COPY,CACHE
CURRENTPROCESSPACKAGE,3,COPY,CACHE
CURRENTPROCESS,3,COPY,CACHE
PROCESSACTIVITY,PROCESSACTIVITY,18,COPY,CACHE
PROCESSACTIVITYPARAMETER,PROCESSACTIVITYPARAMETER,10,COPY,CACHE
BEGIN_DATAVALUE,BEGIN_DATAVALUE
END_DATAVALUE,END_DATAVALUE
SUBPROCESS,SUBPROCESS,13,COPY,CACHE
PROCESSTRANSITION,PROCESSTRANSITION,5,COPY,CACHE
BEGIN_TRANSITIONCONDITION,BEGIN_TRANSITIONCONDITION
END_TRANSITIONCONDITION,END_TRANSITIONCONDITION
COLLECTION,COLLECTION,3,COPY,CACHE
COLLECTIONSHORTCUT,COLLECTIONSHORTCUT,14,COPY,CACHE
INTELLIGENCEMODULE,INTELLIGENCEMODULE,15,COPY,CACHE
QUERYOBJECT,QUERYOBJECT,8,COPY,CACHE
QUERYITEM,QUERYITEM,33,COPY,CACHE
LOV,LOV,8,COPY,CACHE
IOBUSINESSAREA,IOBUSINESSAREA,4,COPY,CACHE
IOBUSINESSAREASHORTCUT,IOBUSINESSAREASHORTCUT,6,COPY,CACHE
CURRENTQUERYOBJECT,CURRENTQUERYOBJECT,5,COPY,CACHE
JOIN,JOIN,16,COPY,CACHE
JOINCOMPONENT,JOINCOMPONENT,13,COPY,CACHE
DRILLPATH,DRILLPATH,12,COPY,CACHE
DRILLLEVEL,DRILLLEVEL,6,COPY,CACHE
DRILLITEM,DRILLITEM,6,COPY,CACHE
DRILLPATHSEGMENT,DRILLPATHSEGMENT,7,COPY,CACHE
REPORTMODULE,REPORTMODULE,15,COPY,CACHE
REPORT,REPORT,8,COPY,CACHE
REPORTITEM,REPORTITEM,16,COPY,CACHE
REPORTGROUP,REPORTGROUP,4,COPY,CACHE
REPORTGROUPSHORTCUT,REPORTGROUPSHORTCUT,7,COPY,CACHE
DERIVATIONSOURCEFCO,DERIVATIONSOURCEFCO,11,COPY,CACHE
DERIVATIONSOURCESCO,DERIVATIONSOURCESCO,16,COPY,CACHE
DERIVEDFCO,DERIVEDFCO,3,COPY,CACHE
PARENTDERIVEDFCO,PARENTDERIVEDFCO,5,COPY,CACHE
SNAPSHOT,SNAPSHOT,5,COPY,CACHE
SNAPSHOTROOT,SNAPSHOTROOT,5,COPY,CACHE

# generic manipulation of MDL to XML conversion
TRIGGERACTION,[GENERIC],1,0,WBUpgrade92to10.handleGenericTransformation

# END Output the remaining objects and the END tags
TRIGGERACTION,[END],1,0,WBUpgrade92to10.processRemainingObjects
TRIGGERACTION,[END],2,0,WBUpgrade92to10.writeRemainingObjects
TRIGGERACTION,[END],3,0,WBUpgrade92to10.writeXMLEndTags

# BEGIN / END text string conversions
TRIGGERACTION,[BEGIN_DESCRIPTION],1,0,WBUpgrade92to10.processBeginDescription
TRIGGERACTION,[BEGIN_EXPRESSION],1,0,WBUpgrade92to10.processBeginExpression
TRIGGERACTION,[BEGIN_PROPERTYVALUE],1,0,WBUpgrade92to10.processBeginPropertyValue
TRIGGERACTION,[BEGIN_ACCESSPARAMETER],1,0,WBUpgrade92to10.processBeginAccessParameter
TRIGGERACTION,[BEGIN_CONDITION],1,0,WBUpgrade92to10.processBeginCondition
TRIGGERACTION,[BEGIN_DATAVALUE],1,0,WBUpgrade92to10.processBeginDataValue
TRIGGERACTION,[BEGIN_NOTE],1,0,WBUpgrade92to10.processBeginNote
TRIGGERACTION,[BEGIN_PACKAGESPEC],1,0,WBUpgrade92to10.processBeginPackageSpec
TRIGGERACTION,[BEGIN_PACKAGEBODY],1,0,WBUpgrade92to10.processBeginPackageBody
TRIGGERACTION,[BEGIN_SYNTAX],1,0,WBUpgrade92to10.processBeginSyntax
TRIGGERACTION,[BEGIN_SELECT],1,0,WBUpgrade92to10.processBeginSelect
TRIGGERACTION,[BEGIN_TRANSITIONCONDITION],1,0,WBUpgrade92to10.processBeginTransitionCondition
TRIGGERACTION,[BEGIN_MLSDESCRIPTION],1,0,WBUpgrade92to10.processBeginMLSDescription
TRIGGERACTION,[BEGIN_DEFAULTVALUE],1,0,WBUpgrade92to10.processBeginDefaultValue

# Environment Upgrade
TRIGGERACTION,[PROJECT],1,0,WBUpgrade92to10.processProject
TRIGGERACTION,[PROJECT],2,1,WBUpgrade92to10Environment.processProjectLocations
TRIGGERACTION,[RUNTIMEREPOSITORYCONNECTION],1,0,WBUpgrade92to10.processGlobalSharedProject
TRIGGERACTION,[RUNTIMEREPOSITORYCONNECTION],2,1,WBUpgrade92to10Environment.processRuntimeRepositoryConnection

# File Upgrade
TRIGGERACTION,[FILE],1,0,WBUpgrade92to10.processFile
TRIGGERACTION,[FIELD],1,0,WBUpgrade92to10.processField

# Module Status Upgrade
TRIGGERACTION,[DATAWAREHOUSE;ORACLEINSTALLEDMODULE;GATEWAYINSTALLEDMODULE;FILEINSTALLEDMODULE;SAPINSTALLEDMODULE;PROCESSMODULE],1,0,WBUpgrade92to10Application.processModuleStatus

# Module Location Upgrade
TRIGGERACTION,[DATAWAREHOUSE;ORACLEINSTALLEDMODULE;GATEWAYINSTALLEDMODULE;FILEINSTALLEDMODULE;SAPINSTALLEDMODULE;PROCESSMODULE],2,1,WBUpgrade92to10Application.processModuleLocation

# Data Warehouse Upgrade
TRIGGERACTION,[DATAWAREHOUSE],3,0,WBUpgrade92to10Application.processDataWarehouse

# Oracle Installed Module Upgrade
TRIGGERACTION,[ORACLEINSTALLEDMODULE],3,0,WBUpgrade92to10Application.processOracleInstalledModule

# Process Flow Module Upgrade
TRIGGERACTION,[PROCESSMODULE],3,0,WBUpgrade92to10Application.processProcessFlowModule

# Process Flow Module Upgrade
TRIGGERACTION,[GATEWAYINSTALLEDMODULE],3,0,WBUpgrade92to10Application.processGatewayInstalledModule

# Named Attribute Set Upgrade
TRIGGERACTION,[NAMEDATTRIBUTESET],2,0,WBUpgrade92to10Relational.processNamedAttributeSet
TRIGGERACTION,[NAMEDATTRIBUTESETATTR],2,0,WBUpgrade92to10Relational.processNamedAttributeSetItem

# Constraints Upgrade
TRIGGERACTION,[UNIQUEKEY],3,1,WBUpgrade92to10Relational.processUniqueKeyAssociations
TRIGGERACTION,[PRIMARYKEY],3,0,WBUpgrade92to10Relational.processPrimaryKey
TRIGGERACTION,[PRIMARYKEY],4,1,WBUpgrade92to10Relational.processUniqueKeyAssociations

# Transformation Upgrade
TRIGGERACTION,[FUNCTION],1,0,WBUpgrade92to10.processFunction
TRIGGERACTION,[FUNCTION],2,1,WBUpgrade92to10.processFunctionReturnType
TRIGGERACTION,[STANDALONEFUNCTION],1,0,WBUpgrade92to10.ignoreKeywords
TRIGGERACTION,[STANDALONEPROCEDURE],1,0,WBUpgrade92to10.ignoreKeywords

# Sequence Upgrade
TRIGGERACTION,[SEQUENCE],1,1,WBUpgrade92to10Relational.processSequence

# Dimension Upgrade
TRIGGERACTION,[DIMENSION],1,0,WBUpgrade92to10Dimensional.identifyDimensionProcessing
TRIGGERACTION,[DIMENSION],2,1,WBUpgrade92to10Dimensional.processDimension
TRIGGERACTION,[COLUMN],2,0,WBUpgrade92to10Dimensional.processDimensionColumn
TRIGGERACTION,[UNIQUEKEY;PRIMARYKEY],2,0,WBUpgrade92to10Dimensional.processDimensionUniqueKey
TRIGGERACTION,[CHECKCONSTRAINT],1,0,WBUpgrade92to10Dimensional.processDimensionCheckConstraint
TRIGGERACTION,[NAMEDATTRIBUTESET],1,0,WBUpgrade92to10Dimensional.processDimensionNamedAttributeSet
TRIGGERACTION,[NAMEDATTRIBUTESETATTR],1,0,WBUpgrade92to10Dimensional.processDimensionNamedAttributeItem
TRIGGERACTION,[MULTILANGUAGESUPPORT],2,0,WBUpgrade92to10Dimensional.processDimensionMultiLanguageSupport

# Level Upgrade
TRIGGERACTION,[LEVEL],1,1,WBUpgrade92to10Dimensional.processLevel
TRIGGERACTION,[COLUMN],1,0,WBUpgrade92to10Dimensional.processLevelAttribute
TRIGGERACTION,[UNIQUEKEY;PRIMARYKEY],1,0,WBUpgrade92to10Dimensional.processLevelUniqueKey

# Hierarchy Upgrade
TRIGGERACTION,[HIERARCHY],1,0,WBUpgrade92to10Dimensional.processHierarchy
TRIGGERACTION,[LEVELRELATIONSHIP],1,0,WBUpgrade92to10Dimensional.processLevelRelationship

# Cube Upgrade
TRIGGERACTION,[FACT],1,1,WBUpgrade92to10Dimensional.processCube
TRIGGERACTION,[MEASURE],1,0,WBUpgrade92to10Dimensional.processMeasure
TRIGGERACTION,[COLUMN],3,0,WBUpgrade92to10Dimensional.processCubeColumn
TRIGGERACTION,[CHECKCONSTRAINT],2,0,WBUpgrade92to10Dimensional.processCubeCheckConstraint
TRIGGERACTION,[MULTILANGUAGESUPPORT],3,0,WBUpgrade92to10Dimensional.processCubeMultiLanguageSupport

# External Table Upgrade
TRIGGERACTION,[EXTERNALTABLE],1,0,WBUpgrade92to10Relational.processExternalTable
TRIGGERACTION,[COLUMN],4,0,WBUpgrade92to10Relational.processExternalTableColumn

# End of FCO Upgrade
TRIGGERACTION,[ENDOFFCO],1,0,WBUpgrade92to10.processRemainingObjects
TRIGGERACTION,[ENDOFFCO],2,0,WBUpgrade92to10.writePreviousFCO

# Mapping Upgrade
TRIGGERACTION,[MAPPING],1,1,WBUpgrade92to10Mapping.processMapping
TRIGGERACTION,[MAPPINGSTAGECOMPONENT],1,0,WBUpgrade92to10Mapping.processMappingStageComponent
TRIGGERACTION,[MAPPINGPARAMETERGROUP],1,0,WBUpgrade92to10Mapping.processMappingParameterGroup
TRIGGERACTION,[MAPPINGPARAMETER],1,0,WBUpgrade92to10Mapping.processMappingParameter
TRIGGERACTION,[MAPPINGDISPLAYSET],1,0,WBUpgrade92to10Mapping.processMappingDisplaySet
TRIGGERACTION,[MAPPINGDISPLAYSETPARAMETER],1,0,WBUpgrade92to10Mapping.processMappingDisplaySetParameter
TRIGGERACTION,[MAPPINGPARAMETERCONNECTION],1,0,WBUpgrade92to10Mapping.processMappingParameterConnection
TRIGGERACTION,[MAPPINGSTAGECOMPONENTPROPERTY;PHYSICALSTAGECOMPONENTPROPERTY;MAPPINGPHYSICALPROPERTY;MAPPINGPARAMETERGROUPPROPERTY;MAPPINGPARAMETERPROPERTY;PHYSICALMAPPINGSTEPPROPERTY],1,0,WBUpgrade92to10Mapping.processMappingProperty

# Process Flow Upgrade
TRIGGERACTION,[CURRENTPROCESSPACKAGE],1,0,WBUpgrade92to10ProcessFlow.processProcessFlowPackage
TRIGGERACTION,[CURRENTPROCESS],1,0,WBUpgrade92to10ProcessFlow.processProcessFlowProcess
TRIGGERACTION,[PROCESSACTIVITY],1,0,WBUpgrade92to10ProcessFlow.processProcessActivity
TRIGGERACTION,[PROCESSACTIVITYPARAMETER],1,0,WBUpgrade92to10ProcessFlow.processProcessActivityParameter
TRIGGERACTION,[SUBPROCESS],1,0,WBUpgrade92to10ProcessFlow.processProcessSubProcess
TRIGGERACTION,[PROCESSTRANSITION],1,0,WBUpgrade92to10ProcessFlow.processProcessTransition

# Collection Upgrade
TRIGGERACTION,[COLLECTION],1,0,WBUpgrade92to10Collection.processCollection
TRIGGERACTION,[COLLECTIONSHORTCUT],1,0,WBUpgrade92to10Collection.processCollectionShortcut

# Metadata Defintion Upgrade
TRIGGERACTION,[METADATADEFINITION],1,0,WBUpgrade92to10.processMetadataDefinition
TRIGGERACTION,[USERDEFINEDPROPERTY],1,0,WBUpgrade92to10.processUserDefinedProperty

# GLH 03/13/06  Added for bug 5082664 to keep track of current snapshot being processed.
TRIGGERACTION,[SNAPSHOT],1,0,WBUpgrade92to10.processSnapshot
TRIGGERACTION,[SNAPSHOTROOT],1,0,WBUpgrade92to10.processSnapshotRoot

# EPS 9/28/06 Bug 5559929
TRIGGERACTION,[MULTILANGUAGESUPPORT],1,0,WBUpgrade92to10.processMLS