# 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.version92
# 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 Preloader
#!
#!----------------------------------------------------------------------  
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
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


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

# To add project name to a list of unique projects in MDL file.
TRIGGERACTION,[PROJECT],1,0,WBPreloader92to10.processProject

# cache Location type information
TRIGGERACTION,[LOCATION],1,0,WBPreloader92to10.processLocation

# cache Connector information
TRIGGERACTION,[CONNECTOR],1,0,WBPreloader92to10.processConnector

# cache module information
TRIGGERACTION,[DATAWAREHOUSE;ORACLEINSTALLEDMODULE;GATEWAYINSTALLEDMODULE;FILEINSTALLEDMODULE;SAPINSTALLEDMODULE;PROCESSMODULE],1,0,WBPreloader92to10.processModule
# GLH 02/04/05 Bug 4067150 - Below no longer needed.
#TRIGGERACTION,[FILEINSTALLEDMODULE],2,0,WBPreloader92to10.processFileModule

# cache foreign key information
TRIGGERACTION,[FOREIGNKEY],1,0,WBPreloader92to10.processForeignKey

# cache dimension hierarchy names
TRIGGERACTION,[HIERARCHY],1,0,WBPreloader92to10.processHierarchy

# cache Fact information
TRIGGERACTION,[FACT],1,0,WBPreloader92to10.processFact
TRIGGERACTION,[FACTFOREIGNKEY],1,0,WBPreloader92to10.processFactForeignKey
TRIGGERACTION,[FACTFOREIGNKEYCOLUMN],1,0,WBPreloader92to10.processFactForeignKeyColumn
TRIGGERACTION,[SEGMENTEDUNIQUEKEY],1,0,WBPreloader92to10.processFactSegmentedUK
TRIGGERACTION,[UNIQUEKEY],1,0,WBPreloader92to10.processFactUniqueKey
TRIGGERACTION,[PRIMARYKEY],1,0,WBPreloader92to10.processFactUniqueKey
TRIGGERACTION,[NAMEDATTRIBUTESET],1,0,WBPreloader92to10.processFactNamedAttributeSet
TRIGGERACTION,[NAMEDATTRIBUTESETATTR],1,0,WBPreloader92to10.processFactNamedAttributeSetItem
TRIGGERACTION,[BEGIN_DESCRIPTION],1,0,WBPreloader92to10.processBeginDescription
TRIGGERACTION,[COLUMN],1,0,WBPreloader92to10.processFactGeneratedColumn

# cache config information
TRIGGERACTION,[CONFIGPARAM;CHILDCONFIG],1,0,WBPreloader92to10.processConfig

# cache Advanced Queue information
TRIGGERACTION,[ADVANCEDQUEUE],1,0,WBPreloader92to10.processAdvancedQueue

# cache Metadata Definition xsdcinformation
TRIGGERACTION,[METADATADEFINITION],1,0,WBPreloader92to10.processMetadataDefinition

# cache Multi-Language Support information
TRIGGERACTION,[MULTILANGUAGESUPPORT],1,0,WBPreloader92to10.processMultiLanguageSupport
TRIGGERACTION,[BEGIN_MLSDESCRIPTION],1,0,WBPreloader92to10.processBeginMLSDescription

# cache User-Defined Property information
TRIGGERACTION,[USERDEFINEDPROPERTY],1,0,WBPreloader92to10.processUserDefinedProperty
TRIGGERACTION,[BEGIN_PROPERTYVALUE],1,0,WBPreloader92to10.processBeginPropertyValue

# GLH 09/15/06  Added for bug 5504848 - cache mapping step type information (i.e. PL/SQL vs. SQL Loader)
TRIGGERACTION,[PHYSICALMAPPINGSTEP],1,0,WBPreloader92to10.processPhysicalMappingStep

# GLH 09/15/06  Added for bug 5504848 - save mapping FQN with module name to be used by processPhysicalMappingStep.
TRIGGERACTION,[MAPPING],1,0,WBPreloader92to10.processMapping

# CJS 01/18/07  Added for bug 5309802 - The names of files in the MDL file need to be cached as part of the MDL upgrade preloading process.
TRIGGERACTION,[FILE],1,0,WBPreloader92to10.processFile

# CJS 01/18/07  Added for bug 5309802 - The names of all constraints in the MDL file need to be cached as part of the MDL upgrade preloading process.
TRIGGERACTION,[PRIMARYKEY;UNIQUEKEY;FOREIGNKEY;FACTFOREIGNKEY;SEGMENTEDUNIQUEKEY],2,0,WBPreloader92to10.cacheConstraintNames
TRIGGERACTION,[CHECKCONSTRAINT],1,0,WBPreloader92to10.cacheConstraintNames