Teradata Numeric overflow occurred during computation
Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...
In this video, we will talk about Numeric Overflow Error.
The error comes when you try to load or compute numeric value which is bigger than the permissible range for numeric datatype used in the query. The solution is cast the column used in computation to bigger numeric datatype.
We will see top 3 different cases in which this error may come and what is the solution in each case.
We referred to following post in this video:
https://etl-sql.com/teradata-numeric-...
Leave a comment if you have any question related to Numeric Overflow error which was not answered in this video.
*One feedback I have received is not to say "right" so many times so will work on it in future videos. :)
![Star Citizen - Making Money with an Aurora [GIVEAWAY]](https://images.videosashka.com/watch/o7JyUhfZ3Wo)
![SQL Timestamp ETL timezone problems are a NIGHTMARE [ETL Scenario -4] #sql #etl](https://images.videosashka.com/watch/7OQGTmU-SHs)
![Aggregate Fact Tables in Data Warehouse - Concept you must know [ETL Scenario -5] #etl #sql #dwh](https://images.videosashka.com/watch/Sy4_pkUqGmE)
![ETL Script Types and Concepts: The Ultimate Guide [ETL Scenario -3] #etl #sql](https://images.videosashka.com/watch/Xol-A26o6MQ)
![Intra-day Job orchestration & SQL: A full tutorial with example [ETL Scenario -2] #etl](https://images.videosashka.com/watch/kbQceQLRRZI)
![Do NOT run DROP TABLE in PRODUCTION. Use 2 alternate solutions [ETL Scenario -1 ] #etl #sql](https://images.videosashka.com/watch/FrlhAScErV8)
![The Frightening Reality Of Missing Records In An ETL Scenario [ETL Scenario -6] #sql #etl](https://images.videosashka.com/watch/w6SRJI0KZ6Q)
