virtual column OGG capture process not working
One of the tables containing a virtual column is sourced from an Oracle DB running on OCI, with BQ as the target.
We encountered a data quality issue: the virtual column data was not received in the target. in testing, used the following configuration in the extraction, but the capture process did not retrieve any data:
Table Configured in Extract Process:
TABLE Schema.Table_Name, FETCHCOLS (Column1, Column2, Column3, Column4);
I wanted to capture all the data in columns the table, including both the regular and virtual columns. Does anyone have an idea why the capture process is not working in this case?