My Teradata SQL query is returning different record count for the same query . When running again and again, count is varying, what can be the issue. Even when running within a minute count is changing.
Can some help in understanding this issue?
FYI,tables that I am joining are not being updated/refreshed.
There might be some RANDOM usage or some OLAP functions without a uinque ORDER BY, hard to tell without the actual source code.
The whole SQL is of around 2000 lines with multiple volatile tables being created in between. Can you help me what should I look for in SQL in order to root cause of issue?
Any occurance of RANDOM (or any non-deterministic UDF created on your system) or OLAP-functions used in QUALIFY based on a non-unique ORDER BY.