Data Replication
- Data Replication 9.8.0
- All Products
<ConversionRule source_db="ORACLE" destination_db="NETEZZA"> <DataTypes> <DataType> <OriginalDataType>NUMBER</OriginalDataType> <Condition><![CDATA[DataPrecision>18 && DataScale==0]]></Condition> <DataPrecision>DestinationDataPrecision=DataPrecision</DataPrecision> <DataScale>DestinationDataScale=DataScale</DataScale> <DestinationDataType>NUMERIC</DestinationDataType> </DataType> </DataTypes> </ConversionRule>
If the character sets of the source and target CHAR columns do not match, the target column size in bytes might differ from the source column size. In this case, Data Replication uses the following formula to calculate the target column size:<ConversionRule source_db="ORACLE" destination_db="TERADATA"> </DataTypes> <DataType> <OriginalDataType>VARCHAR</OriginalDataType> <DestinationDataType>VARCHAR</DestinationDataType> <Calculation>DestinationDataSize=(DataSize+SrcMinCharsetSize-1)/SrcMinCharsetSize*TgtCharsetSize</Calculation> </DataType> </DataTypes> </ConversionRule>
DestinationDataSize=(DataSize+SrcMinCharsetSize-1)/SrcMinCharsetSize*TgtCharsetSize
Replace the<DataType> <OriginalDataType>source_column_datatype</OriginalDataType> <Condition>rule_condition<Condition> <DestinationDataType>target_column_datatype</DestinationDataType> </DataType>