Data type conversions occurrences when working with databases are the natural behaviour of DQC. When reading data from a database (e.g. using JDBC Reader step), the data type is read from the database and transformed into DQC data type.
DQC internally works with its own data types. When writing the data back to the database (in such case, JDBS Writer step is commonly used), data type alternation takes place. The rules for data types conversions are defined in SQL Transformation Rules. There is a possibility to change from what exact database types there will be a conversion to DQC types.
To redefine the database types from which DQC will transform data into its own data types:
- Go to Window > Preferences
- Select Ataccama DQC > Database > SQL Transformation Rules
- Modify SQL transformation rules of the specific database product you use