Teradata Database Message 4514 - 4514 - Analytics Database - Teradata Vantage

Message

Write disallowed by Unity because query contains a non-deterministic element.

Explanation

This error is returned when a non-deterministic query is detected and CDC is not supported/available. For example: - write to a table containing an identity column. - write using a sub-select that contains a TOP clause without an ORDER BY clause - write using a sub-select that contains a SAMPLE clause

Generated By

Unity

For Whom

End User.

Notes

None

Remedy

Unity requires CDC feature to be enabled to replicate this request. Please enable the CDC/CDM feature in Unity and Teradata.