How To Use Built-in Functions in Teradata?

First of all what are Built-in functions? These are functions which do not need any sort of arguments but still returns information about the system; user, date, time, session etc. Built-in functions are sometimes referred to as special registers. Mostly used with the SELECT statement. SELECT <Built-In Function> • ACCOUNT: – If you are wondering …

Continue reading

LIKE with ESCAPE sequence

like, teradata, wild card characters, escape sequence, escape in like

Components of Teradata

Teradata is made up of following components – Processor Chip – The processor is the BRAIN of the Teradata system. It is responsible for all the processing done by the system. All task are done according to the direction of the processor. Memory – The memory is known as the HAND of the Teradata system. …

Continue reading

Teradata Architecture

Teradata Architecture is the key component to learn Teradata.

How to get Case Sensitivity in Teradata

case specific in teradata

Limitations of FAST LOAD

limitation of fastload, fastload, teradata utilities, secondary index

Teradata Utilities : FASTLOAD – Part 1

fastload teradata utilities, teradata utilities fastload