Tech Diary

Teradata SQL Syntax error: All expressions in a derived table must have an explicit name.

The below statement threw this error: SQL Syntax error: All expressions in a derived table must have an explicit name. select v1.* from di...
Teradata SQL INDEX function

This is equivalent to ANSI SQL POSITION function. Example: SELECT INDEX('Teradata', 'd'); Returns 5 SELECT INDEX(&#...
Basis Points

1 basis point = 1/100 of a percentage. Used mainly in Finance like changes in interest rate. Example: "The Federal Open Market Commi...
Different types of VPN

Different types of VPNs: 1. Site-to-Site VPN, 2. Dynamic VPN (DMVPN), 3. Client VPN, 4. SSLVPN is explained clearly in this blog. http:...
Treasury Stock

When a comany buys back its own shares and doesn’t retire them, those shares are called Treasury Stock
Teradata sql - retrieve top and bottom 50 percentage of the records

Top 50% ---------- select top 50 percent * from table1 order by id asc Bottom 50% --------------- select top 50 percent * from ta...
Teradata SQL Regular Expression to compare date format

Verify if date is in format dd-MMM-yyyy select regexp_similar(a_date,'^(([0-9])|([0-2][0-9])|([3][0-1]))\-(JAN|FEB|MAR|APR|MAY|JUN|J...
(no title)

Some Teradata Warehouse Appliance 2700 facts Ref: http://www.teradata.com/brochures/teradata-data-warehouse-appliance-2700/
Spider - SPDR

Stands for Standard & Poor’s Depository Receipt. It is a S&P 500 index based ETF maintained by State Street Global Advisors. Each sh...
Quadruple Witching

Quadruple Witching refers to the 3rd Friday of every quarter i.e March, June, September and December. This is the trading day when: mar...

Simple theme. Powered by Blogger.