test.olj

数据仓库工具

<?xml version="1.0" encoding="UTF-8" ?>
<loaderJob logMode="normal" objectIDIncrement="1" objectIDTableName="objectid" objectIDColumnName="next" commitCount="1" dataCutOff="true">
	<jdbcDefaultParameters>
		<jdbcSourceParameters dbVendor = "csv">
			<jdbcSourceParameter name="JdbcDriver" value="org.relique.jdbc.csv.CsvDriver"/>
			<jdbcSourceParameter name="Connection.Url" value="jdbc:relique:csv:ObjectLoader/LoaderInput"/>
		</jdbcSourceParameters>
		<jdbcTargetParameters dbVendor="Xml" driverName="xml">
			<jdbcTargetParameter name="JdbcDriver" value="org.webdocwf.util.xml.XmlDriver"/>
			<jdbcTargetParameter name="Connection.Url" value="jdbc:webdocwf:xml:ObjectLoader/LoaderOutput/Testdatabase"/>
	  </jdbcTargetParameters>
	</jdbcDefaultParameters>
	<sql name="CreateTables" onErrorContinue="false" commit="true">
	<jdbcTargetParameters dbVendor="Xml" driverName="xml">
			<jdbcTargetParameter name="JdbcDriver" value="org.webdocwf.util.xml.XmlDriver"/>
			<jdbcTargetParameter name="Connection.Url" value="jdbc:webdocwf:xml:ObjectLoader/LoaderOutput/Testdatabase"/>
	</jdbcTargetParameters>
		<sqlStmt>
			<include href="ObjectLoader/includes/CreateXMLTables.sql" parse="text"/>
		</sqlStmt>
	</sql>
		<sql name="CreateOidDODS" onErrorContinue="false" commit="true">
		<sqlStmt>
			<include href="ObjectLoader/includes/CreateXMLOidAdminData.sql" parse="text"/>
		</sqlStmt>
	</sql>

  <copyTable logMode="normal" name="IMAGES" objectIDIncrement="20" oidLogic="false" onErrorContinue="false" sourceTableName="IMAGES" targetTableName="IMAGES"/>

	<definitionInclude>
		<include href="ObjectLoader/BooksDefinition.oli" parse="xml"/>
	</definitionInclude>

	<importDefinition name="BOOKS" tableName="BOOKS" logMode="normal" objectIDIncrement="20" onErrorContinue="true" dataCutOff="true">
		<valueColumns>
			<valueColumn sourceColumnName="BOOKNAME" targetTableName="BOOKS" targetColumnName="BOOKNAME" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="LANGUAGE" targetTableName="BOOKS" targetColumnName="LANGUAGE" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="KEYVALUE" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="0" valueMode="Key"/>
			<valueColumn sourceColumnName="XMLNAME" targetTableName="BOOKS" targetColumnName="XMLNAME" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER01DESC" targetTableName="BOOKS" targetColumnName="CHAPTER01DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER02DESC" targetTableName="BOOKS" targetColumnName="CHAPTER02DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER03DESC" targetTableName="BOOKS" targetColumnName="CHAPTER03DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER04DESC" targetTableName="BOOKS" targetColumnName="CHAPTER04DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER05DESC" targetTableName="BOOKS" targetColumnName="CHAPTER05DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER06DESC" targetTableName="BOOKS" targetColumnName="CHAPTER06DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER07DESC" targetTableName="BOOKS" targetColumnName="CHAPTER07DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER08DESC" targetTableName="BOOKS" targetColumnName="CHAPTER08DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER09DESC" targetTableName="BOOKS" targetColumnName="CHAPTER09DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER10DESC" targetTableName="BOOKS" targetColumnName="CHAPTER10DESC" targetTableID="0" valueMode="Overwrite"/>
		</valueColumns>
		<transformations>
	 		<transformation name="BooknameTrans" transformatorClassName="BooknameTransformer" transformatorConfig="1">
				<sourceColumns>
					<sourceColumn name="BOOKNAME"/>
				</sourceColumns>
				<targetColumns>
					<targetColumn name="TRANSF1" tableName="TRANSBOOKNAME" tableID="0" valueMode="Overwrite"/>
					<targetColumn name="TRANSF2" tableName="TRANSBOOKNAME" tableID="0" valueMode="Overwrite"/>
					<targetColumn name="TRANSF3" tableName="TRANSBOOKNAME" tableID="1" valueMode="SetNull"/>
				</targetColumns>
			</transformation>
			<transformation name="LanguageTrans" transformatorClassName="LanguageTransformer" transformatorConfig="2">
				<sourceColumns>		
					<sourceColumn name="LANGUAGE"/>
				</sourceColumns>
				<targetColumns>	
					<targetColumn name="TRANSLANGUAGE1" tableName="TRANSLANGUAGE" tableID="1" valueMode="Overwrite"/>
				</targetColumns>
			</transformation>
		</transformations>
		<tables>
			<table tableName="BOOKS" tableID="0" insert="true" tableMode="Query" oidLogic="true"/>
		</tables>
	</importDefinition>
	<importDefinition name="BOOKLINKS" tableName="BOOKLINKS" logMode="normal" objectIDIncrement="20" >
		<valueColumns>
			<valueColumn sourceColumnName="TYPEKEY" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="9" valueMode="Key"/>
			<valueColumn sourceColumnName="BOOKLINENUMBER" targetTableName="BOOKLINKS" targetColumnName="BOOKLINENUMBER" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="KEYVALUE" targetTableName="BOOKLINKS" targetColumnName="KEYVALUE" targetTableID="0" valueMode="Key"/>
			<valueColumn sourceColumnName="XMLNAME" targetTableName="BOOKLINKS" targetColumnName="XMLNAME" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING01" targetTableName="BOOKLINKS" targetColumnName="URLSTRING01" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING02" targetTableName="BOOKLINKS" targetColumnName="URLSTRING02" targetTableID="0" valueMode="Overwrite" defaultValue="defColVal"/>
			<valueColumn sourceColumnName="URLSTRING03" targetTableName="BOOKLINKS" targetColumnName="URLSTRING03" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING04" targetTableName="BOOKLINKS" targetColumnName="URLSTRING04" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING05" targetTableName="BOOKLINKS" targetColumnName="URLSTRING05" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING06" targetTableName="BOOKLINKS" targetColumnName="URLSTRING06" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING07" targetTableName="BOOKLINKS" targetColumnName="URLSTRING07" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING08" targetTableName="BOOKLINKS" targetColumnName="URLSTRING08" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING09" targetTableName="BOOKLINKS" targetColumnName="URLSTRING09" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING10" targetTableName="BOOKLINKS" targetColumnName="URLSTRING10" targetTableID="0" valueMode="Overwrite"/>
		</valueColumns>
		<relationColumns>
			<relationColumn relationSourceTableName="BOOKS" relationSourceColumnName="BOOKOID" relationSourceTableID="9" relationTargetTableName="BOOKLINKS" relationTargetColumnName="BOOKOID" relationTargetTableID="0" relationMode="Overwrite"/>
		</relationColumns>
		<tables>
			<table tableName="BOOKS" tableID="9" insert="false" tableMode="Query" oidLogic="true"/>
			<table tableName="BOOKLINKS" tableID="0" insert="true" tableMode="Query" oidLogic="true"/>
		</tables>
	</importDefinition>
	<importDefinition name="RelationBooks" tableName="BOOKLINKS" logMode="normal" objectIDIncrement="20" >
		<valueColumns>
			<valueColumn sourceColumnName="KEYVALUE" targetTableName="BOOKLINKS" targetColumnName="KEYVALUE" targetTableID="0" valueMode="Key"/>
			<valueColumn sourceColumnName="TYPEKEY" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="1" valueMode="Key"/>
			<valueColumn sourceColumnName="BOOKKEY" targetTableName="BOOKLINKS" targetColumnName="KEYVALUE" targetTableID="2" valueMode="Key"/>
			<valueColumn sourceColumnName="BOOKTYPEKEY" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="3" valueMode="Key"/>
		</valueColumns>
		<relationColumns>
			<relationColumn relationSourceTableName="BOOKLINKS" relationSourceTableID="2" relationTargetTableName="BOOKLINKS" relationTargetColumnName="BOOKLINKSOID" relationTargetTableID="0" relationMode="Overwrite" defaultValue="SELECT oid FROM BOOKLINKS WHERE KEYVALUE='HOME'"/>
		</relationColumns>
		<tables>
			<table tableName="BOOKS" tableID="1" insert="false" tableMode="Cache" oidLogic="true"/>
			<table tableName="BOOKLINKS" tableID="0" insert="false" tableMode="Cache" oidLogic="true"/>
			<table tableName="BOOKS" tableID="3" insert="false" tableMode="Cache" oidLogic="true"/>
			<table tableName="BOOKLINKS" tableID="2" insert="false" tableMode="Cache" oidLogic="true"/>
		</tables>
	</importDefinition>

</loaderJob>