I am new to oracle data quality. I have created a simple cleansing project with the following objects:
1. Entity "Customer" which rappresents the input data;
2. Transformer to convert a string into a number;
I would like to export all the data trasformed into a delimited file where each field must be separeted by the character tilde "~".
I have seen the feature in ODQ (right-click on the data) to export all the rows but it generates a flat file delimited by "tab". What I would like to perform is an automatic system that generates a flat file delimited by tilde at the end of the cleansing process.