Tags » Teradata

How to get Session ID in Teradata vs Oracle

Getting Session ID in Teradata is trivial:

SELECT SESSION

In Oracle, you would need to use sys_context (Oracle 10g and up)  or userenv function (legacy function) if you are not permitted to reference v$mystat or some other dynamic performance views: 14 more words

ORACLE

Nearly 50% of CEOs believe all of their employees have access to the data they need, only 27% of employees agree

Source: Teradata and EIU

RTBlog:

Nearly half of CEOs believe that all of their employees have access to the data they need, but only 27% of employees agree. 156 more words

Teradata

netezza?teradata? ?now hadoop ?

As I sit browsing through.. I found a good piece for info showcasing the importance of hadoop .. our tiny elephant.. and how it’s different from the mighty Teradata or Netezza.. 481 more words

Information Management

How to Copy a Table: Teradata vs Oracle syntax

In Oracle, you copy a table with the following CREATE TABLE statement:

CREATE TABLE <table_copy> AS 
SELECT * FROM <table>

And if you only want to copy the structure (with no content) you add WHERE clause that filters out all rows: 70 more words

Tricks And Workarounds

Big Analytics Roundup (May 9, 2016)

The big news this week: Teradata’s CEO Mike Keough walks the plank. TDC stock rises 21% on dismal numbers, which demonstrates how much Wall Street values leadership. 615 more words

Apache Spark

Teradata Reports Loss, Fires CEO

After three years of strategic floundering, Teradata now understands that it has a leadership problem, and announces a CEO change. Victor Lund, who heads the audit committee on the board, takes the helm. 416 more words

News Analysis

Teradata Database Management Online Training in SRY IT Solutions

Teradata is a completely scalable system of relational database organization formed by Teradata Corporation. It is greatly used to organize a large amount of data operations of warehousing and treats as one specific data storage which accepts a good number of simultaneous requests from different customer applications. 447 more words