Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: Glossary

Empty String Values in Non Null Columns

Empty String Values in Non Null Columns

A reset job fails if the data contains empty string values to copy to a non null column in the target.
You might encounter this issue when you reset a data set that you create on an Oracle test data warehouse to a Microsoft SQL Server database.
You can configure a project to provide default values to use for empty string values in non null target columns. To provide the default values, the project configuration must contain an additional field. All plans that you run from the project use the default values. You can edit the values as required.
On a Microsoft SQL Server target, a reset job replaces empty string values with values provided in the project if the target column is a non null column.
On an Oracle target, a reset job replaces the values provided in the project with empty string values if the target column is a non null column.
A reset job fails if the non null columns in the target are unique columns.