Profile cover photo
Profile photo
srini P (srinimf)
6 followers
6 followers
About
Communities and Collections
View all
Posts

Post has attachment
5 Top Teradata DATE functions read now
Teradata Functions The following are the list of DATE functions. These are very frequently being used in Teradata. Current DATE The following statement requests the current system date: SELECT CURRENT_DATE;
The system responds with something like the follow...

Post has attachment
How to Know Teradata is in Pseudo table Lock
The pseudo table mechanism is a way to serially queue all table level locks through the use of an internal pseudo table. In this table the database locks the row hash of the table's table ID. What does” Pseudo Table” Locks mean in EXPLAIN Plan in Teradata?...

Post has attachment
Teradata Quick refresher: TPump,MultiLoad,FastExport Utilities
Teradata utilities are very important while working with SQL and in data warehousing projects. The below short and crispy definitions help you can use while attending for interviews or in your day to day work to refresh your Teradata knowledge. MultiLoad  -...

Post has attachment
How to use Null value functions in Teradata for Handling Nulls
NULL functions The below are the Null value functions in Tearadata. One is "NVL" and another one is "NVL2". These two functions are part of Teradata SQL. NVL - The NVL function replace null value with a string or numeric value. This is the functionality is ...

Post has attachment
The best guide for Teradata SQL for smarties
MPP architecture The largest systems in the world have used Teradata for market dominance for the past
20 years. Its Massively Parallel Processing (MPP) technology analyzes on such a
large scale that companies can run queries they have never been able to ...

Post has attachment
5 Things about Teradata everyone wants to know
Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations. The Teradata database system is based on off-the-shelf symmetric multiprocessing technology combined...

Post has attachment
How to refresh Hadoop the best way in three minutes

Post has attachment
How to write best CASE example in Teradata SQL
Teradata Case Statement What is CASE statement? CASE will provide logical control of the SQL. In CASE statement we can give >,<,=,<> The CASE has structure it starts with CASE and end with END See an example of Advanced CASE: SELECT   COMPANY,   CASE     WH...

Post has attachment
How to Know Teradata is in Pseudo table Lock
The pseudo table mechanism is a way to serially queue all table level locks through the use  of an internal pseudo table. In this table the database locks the row hash of   the table's table ID. What does” Pseudo Table” Locks mean in EXPLAIN Plan in Teradat...

Post has attachment
Wait while more posts are being loaded