All Stories

Teradata Date Handling with Sample Queries

Teradata Date Handling: For Developer, handling the date is a very tedious task. the date format must be checked before inserting the date in the table. there are many ways to handle it. Sample table: CREATE VOLATILE TABLE SAMPLE_DATE, NO…
Teradata connector Stage in Datastage

The Teradata Connector stage in DataStage allows to read and write records to the Teradata tables. The Teradata Connector stage has many capabilities and Better than earlier Teradata stages. Teradata API, Teradata Enterprise, Teradata Load and Teradata Multiload stages are depreciated,…
Teradata Compression (MVC)

The purpose of this article is to explain in simple steps what the  Teradata Multi-value compression (MVC) is in Teradata, how anybody working with Teradata can utilize this and how one can measure the space saving. What is Teradata compression? Compression…

There are three types of temporary tables in teradata . Global Volatile Derived Global temporary tables : The scope of global temporary tables limited to the session only . when session ends  all the records are dropped but the definition or…