# this is the rule file for the MDL # header information PRODSRCRELEASE=9.1.0.5.0 PRODTGTRELEASE=9.0.3.22.0 SRCRELEASE=10.2 TGTRELEASE=11.3 SRCMDLRELEASE=10.2 TGTMDLRELEASE=11.3 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 # will be replaced with the date and time while will be replaced with the old release version BEGIN_HEADER #!---------------------------------------------------------------------- #! #! Oracle Warehouse Builder Upgrade Utility #! Upgraded from 9.2 to 10.0 #! #!---------------------------------------------------------------------- END_HEADER # actual rules # generic manipulation of MDL to XML conversion TRIGGERACTION,[GENERIC],1,0,WBUpgrade10to11.handleGenericTransformation TRIGGERACTION,[ENDOFFCO],1,0,WBUpgrade10to11.writeCurrentFCO TRIGGERACTION,[END],1,0,WBUpgrade10to11.writeXMLEndTags TRIGGERACTION,[PROJECT],1,0,WBUpgrade10to11.processProject TRIGGERACTION,[CFA],1,0,WBUpgrade10to11.processCFA TRIGGERACTION,[OWBAssoc_ReferencedDimensionAttribute],1,0,WBUpgrade10to11.processReferencedDimensionAttributeAssoc TRIGGERACTION,[OWBAssoc_BindingDimensionKeyAttribute],1,0,WBUpgrade10to11.processBindingDimensionKeyAttributeAssoc TRIGGERACTION,[OWBAssoc_DefaultDateHierarchyTemplate],1,0,WBUpgrade10to11.processDefaultDateHierarchyTemplateAssoc TRIGGERACTION,[OWBAssoc_RemoteJoinComponentReferences],1,0,WBUpgrade10to11.processRemoteJoinComponentReferencesAssoc TRIGGERACTION,[OWBAssoc_ExtRelationalCaptureMechanism],1,0,WBUpgrade10to11.processExtRelationalCaptureMechanismAssoc TRIGGERACTION,[OWBAssoc_OwnedWeakSecondClassObjects],1,0,WBUpgrade10to11.processOwnedWeakSecondClassObjectsAssoc TRIGGERACTION,[OWBAssoc_ReferencedDefinitionElement],1,0,WBUpgrade10to11.processReferencedDefinitionElementAssoc TRIGGERACTION,[OWBAssoc_OwnedAssociationDefinitions],1,0,WBUpgrade10to11.processOwnedAssociationDefinitionsAssoc TRIGGERACTION,[MAPPING],1,0,WBUpgrade10to11.processMapping TRIGGERACTION,[OPERATOR],1,0,WBUpgrade10to11.processMapOperator TRIGGERACTION,[GROUP],1,0,WBUpgrade10to11.processMapGroup TRIGGERACTION,[ATTRIBUTE],1,0,WBUpgrade10to11.processMapAttribute TRIGGERACTION,[STRINGPROPERTYVALUE],1,0,WBUpgrade10to11.processStringPropertyValue TRIGGERACTION,[DATA_AUDITOR],1,0,WBUpgrade10to11.processDataRuleMap TRIGGERACTION,[PLUGGABLE_MAPPING],1,0,WBUpgrade10to11.processPublicSubMap TRIGGERACTION,[DIMENSION],1,0,WBUpgrade10to11.processDimension TRIGGERACTION,[CUBE],1,0,WBUpgrade10to11.processCube TRIGGERACTION,[PROFILE_FOREIGN_KEY],1,0,WBUpgrade10to11.processMultipleAttr TRIGGERACTION,[PROFILE_UNIQUE_KEY],1,0,WBUpgrade10to11.processMultipleAttr TRIGGERACTION,[STREAMS_CAPTURE_PROCESS],1,0,WBUpgrade10to11.processStreamsCaptureProcess TRIGGERACTION,[BUSINESS_PRESENTATION_MODULE],1,0,WBUpgrade10to11.processBusinessPresenationModule TRIGGERACTION,[LOCATION],1,0,WBUpgrade10to11.processLocation TRIGGERACTION,[ORACLE_MODULE],1,0,WBUpgrade10to11.processDatabaseModule TRIGGERACTION,[OWBAssoc_SoftwareModuleVersion],1,0,WBUpgrade10to11.processSoftwareModuleVersionAssoc TRIGGERACTION,[DATA_PROFILE],1,0,WBUpgrade10to11.processDataProfile TRIGGERACTION,[FUNCTIONAL_DEPENDENCY],1,0,WBUpgrade10to11.processMultipleAttr TRIGGERACTION,[ROW_RELATIONSHIP],1,0,WBUpgrade10to11.processMultipleAttr TRIGGERACTION,[GATEWAY_MODULE],1,0,WBUpgrade10to11.processDatabaseModule TRIGGERACTION,[OWBAssoc_TypeDefinition],1,0,WBUpgrade10to11.processTypeDefinitionAssoc TRIGGERACTION,[SAP_MODULE],1,0,WBUpgrade10to11.processSAPModule TRIGGERACTION,[FLAT_FILE_MODULE],1,0,WBUpgrade10to11.processFlatFileModule TRIGGERACTION,[BUSINESS_DEFINITION_MODULE],1,0,WBUpgrade10to11.processBusinessDefinitionModule TRIGGERACTION,[DRILL_PATH],1,0,WBUpgrade10to11.processDrillPath TRIGGERACTION,[DRILL_LEVEL],1,0,WBUpgrade10to11.processDrillLevel TRIGGERACTION,[DRILLITEM],1,0,WBUpgrade10to11.processDrillItem TRIGGERACTION,[JOIN],1,0,WBUpgrade10to11.processJoin TRIGGERACTION,[ITEM],1,0,WBUpgrade10to11.processQueryItem TRIGGERACTION,[ITEM_FOLDER],1,0,WBUpgrade10to11.processQueryObject TRIGGERACTION,[BUSINESS_AREA],1,0,WBUpgrade10to11.processIntelligenceBusinessArea TRIGGERACTION,[OWBAssoc_FCO],1,0,WBUpgrade10to11.processIntelligenceBusinessAreaShortcutFCOAssoc TRIGGERACTION,[OWBAssoc_RelatedDesignFCO],1,0,WBUpgrade10to11.processRelatedDesignFCOAssoc TRIGGERACTION,[CONFIGURATION],1,0,WBUpgrade10to11.processConfiguration TRIGGERACTION,[PHYSICALOBJECT],1,0,WBUpgrade10to11.processPhysicalObject TRIGGERACTION,[OWBAssoc_NamedConfiguration],1,0,WBUpgrade10to11.processNamedConfigurationAssoc TRIGGERACTION,[COLLECTION],1,0,WBUpgrade10to11.processCollection TRIGGERACTION,[PROCESS_FLOW_MODULE],1,0,WBUpgrade10to11.processProcessFlowModule TRIGGERACTION,[SNAPSHOT],1,0,WBUpgrade10to11.processSnapshot TRIGGERACTION,[SNAPSHOTROOT],1,0,WBUpgrade10to11.processSnapshotRoot TRIGGERACTION,[PUREPHYSICALOBJECT],1,0,WBUpgrade10to11.processPurePhysicalObject TRIGGERACTION,[FUNCTIONIMPLEMENTATION],1,0,WBUpgrade10to11.processFunctionImplementation TRIGGERACTION,[SHARED_MODULE],1,0,WBUpgrade10to11.processSharedModule TRIGGERACTION,[FUNCTION],1,0,WBUpgrade10to11.processFunction TRIGGERACTION,[EXPERT_MODULE],1,0,WBUpgrade10to11.processExpertModule TRIGGERACTION,[EXPERT],1,0,WBUpgrade10to11.processExpert TRIGGERACTION,[USER],1,0,WBUpgrade10to11.processUser TRIGGERACTION,[ROLE],1,0,WBUpgrade10to11.processRole TRIGGERACTION,[CONTROL_CENTER],1,0,WBUpgrade10to11.processControlCenter TRIGGERACTION,[DEPLOYMENT],1,0,WBUpgrade10to11.processDeployment TRIGGERACTION,[GENERIC_MODULE],1,0,WBUpgrade10to11.processGenericModule TRIGGERACTION,[OWBAssoc_Attribute],1,0,WBUpgrade10to11.processAttributeAssoc TRIGGERACTION,[OWBAssoc_Location],1,0,WBUpgrade10to11.processLocationAssoc TRIGGERACTION,[OWBAssoc_ReferencingObject],1,0,WBUpgrade10to11.processReferencingObjectAssoc TRIGGERACTION,[OWBAssoc_OwningFolder],1,0,WBUpgrade10to11.processOwningFolderAssoc TRIGGERACTION,[ACCESSPREFERENCE],1,0,WBUpgrade10to11.processAccessPreference TRIGGERACTION,[CONNECTOR],1,0,WBUpgrade10to11.processConnector TRIGGERACTION,[OWBAssoc_ReferencedElement],1,0,WBUpgrade10to11.processReferencedElementAssoc TRIGGERACTION,[OWBAssoc_LogicalObject],1,0,WBUpgrade10to11.processLogicalObjectAssoc TRIGGERACTION,[REFERENCEPROPERTYVALUE],1,0,WBUpgrade10to11.processReferencePropertyValue TRIGGERACTION,[OWBAssoc_ReferredType],1,0,WBUpgrade10to11.skipOWBAssoc TRIGGERACTION,[OWBAssoc_DerivationSourceSCO],1,0,WBUpgrade10to11.skipDerivationOWBAssoc TRIGGERACTION,[OWBAssoc_DerivedFCO],1,0,WBUpgrade10to11.skipDerivationOWBAssoc TRIGGERACTION,[OWBAssoc_DerivationSourceFCO],1,0,WBUpgrade10to11.skipDerivationOWBAssoc TRIGGERACTION,[OWBAssoc_ParentDerivedFCO],1,0,WBUpgrade10to11.skipOWBAssoc TRIGGERACTION,[PACKAGE],1,0,WBUpgrade10to11.processPackage TRIGGERACTION,[DATA_RULE_MODULE],1,0,WBUpgrade10to11.processDataRuleModule TRIGGERACTION,[CALENDAR_MODULE],1,0,WBUpgrade10to11.processCalendarModule TRIGGERACTION,[INDEX],1,0,WBUpgrade10to11.removeIndexAttributes TRIGGERACTION,[PARTITION_KEY],1,0,WBUpgrade10to11.removePartitionKeyAttributes TRIGGERACTION,[PARTITION],1,0,WBUpgrade10to11.removePartitionAttributes TRIGGERACTION,[FLAT_FILE],1,0,WBUpgrade10to11.processFlatFile TRIGGERACTION,[FIELD],1,0,WBUpgrade10to11.processField TRIGGERACTION,[ITEMSETUSAGE],1,0,WBUpgrade10to11.processItemSetUsage TRIGGERACTION,[OBJECT_TYPE_ATTRIBUTE],1,0,WBUpgrade10to11.processObjectTypeAttribute TRIGGERACTION,[ADVANCED_QUEUE],1,0,WBUpgrade10to11.processAdvancedQueue TRIGGERACTION,[OWBAssoc_PayloadType],1,0,WBUpgrade10to11.skipOWBAssoc TRIGGERACTION,[SQLCOLLECTION],1,0,WBUpgrade10to11.processSqlCollection TRIGGERACTION,[QUEUE_PROPAGATION],1,0,WBUpgrade10to11.processQueuePropagation TRIGGERACTION,[DIMENSION_ATTRIBUTE],1,0,WBUpgrade10to11.processDimensionAttribute TRIGGERACTION,[LEVEL],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[LEVEL_ATTRIBUTE],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[HIERARCHY],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[CUBEDEFAGGRMETHOD],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[DIMENSION_USE],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[COMPOSITE_DIMENSION],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[COMPOSITEDIMENSIONUSAGE],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[DIMENSIONROLE],1,0,WBUpgrade10to11.removeAwObjectNameAttr TRIGGERACTION,[PARAMETER],1,0,WBUpgrade10to11.processParameter TRIGGERACTION,[CLOBPROPERTYVALUE],1,0,WBUpgrade10to11.processClobPropertyValue TRIGGERACTION,[DEPENDENCY],1,0,WBUpgrade10to11.processDependency TRIGGERACTION,[ITEM_CLASS],1,0,WBUpgrade10to11.processLovItemClass TRIGGERACTION,[OWBAssoc_RelatedAttribute],1,0,WBUpgrade10to11.processRelatedAttributeAssoc TRIGGERACTION,[INTELLBUSAREASHORTCUT],1,0,WBUpgrade10to11.processIntelligenceBusAreaShortcut TRIGGERACTION,[PROCESS_FLOW],1,0,WBUpgrade10to11.processProcessFlow TRIGGERACTION,[SUBPROCESS],1,0,WBUpgrade10to11.processSubProcess TRIGGERACTION,[TRANSITION],1,0,WBUpgrade10to11.processTransition TRIGGERACTION,[BUSINESSTREESHORTCUT],1,0,WBUpgrade10to11.processBusinessTreeShortcut TRIGGERACTION,[TRANSPORTABLE_MODULE],1,0,WBUpgrade10to11.processTransportableModule TRIGGERACTION,[ORACLETTSUSAGE],1,0,WBUpgrade10to11.processOracleTTSUsage TRIGGERACTION,[TRANSPORTABLE_MODULE_TABLESPACE],1,0,WBUpgrade10to11.processTransportableModuleTablespace TRIGGERACTION,[TRANSPORTABLE_MODULE_DATAFILE],1,0,WBUpgrade10to11.processTransportableModuleDatafile TRIGGERACTION,[SCHEDULE],1,0,WBUpgrade10to11.processSchedule TRIGGERACTION,[ICONSET],1,0,WBUpgrade10to11.processIconSet TRIGGERACTION,[JOIN_COMPONENT],1,0,WBUpgrade10to11.processJoinComponent TRIGGERACTION,[CONDITION],1,0,WBUpgrade10to11.processQueryCondition TRIGGERACTION,[OWBAssoc_Wbrole],1,0,WBUpgrade10to11.processWbroleAssoc TRIGGERACTION,[VARIABLE],1,0,WBUpgrade10to11.processVariable TRIGGERACTION,[HIERARCHYLEVELUSAGE],1,0,WBUpgrade10to11.processHierarchyLevelUsage TRIGGERACTION,[ORACLE_MODULE_CATALOG],1,0,WBUpgrade10to11.processDatabaseModuleCatalog TRIGGERACTION,[OWB_CATALOG],1,0,WBUpgrade10to11.processOWBCatalog