Has anyone come across this issue...
Running version 11.5.01 of TSCO
We are using an ETL task which is a ‘Generic – Database Extractor (java)’
We are noticing for every 12:00 (midday) instance the value is blank, and the value that should be in the 12:00 (midday) instance, is actually in the 00:00 (midnight) instance.
This happens for every day of the month – the midday field is blank and its value is in the midnight field, overwriting the value that should be in the 00:00 midnight field.
This is an example from the SQL before the ETL task processes it, and as you can see in the highlighted figures and data table image the 12:00 (midday) field should be in the 00:00 (midnight) field.
above shows the data table after the ETL task has processed it.
This is the SQL Query we are using:
The DB is Oracle and we use an external DB connection.
I suggest you open a support case for this one.