Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Blog Directory  >  Blogging Blogs  >  Guides Blogs  >  Teradata SQL Reference guides Blog  > 

2013-12-21 03:26
The data distribution of table among AMPs is called Skew Factor.Generally for NUPI, we get duplicate values, so the more dulicate values you get the more the data will have the same row hash… Read More
2013-07-19 09:03
TPump is similar to MLoad, TPump edits Teradata tables by processing insert, updates, and deletes.TPump performs updates on the Teradata Database in a synchronous manner. Changes are sent in… Read More
2013-07-08 07:44
TPump is a data loading utility that helps you maintain (update, delete, insert, and atomic upsert) the data in your Teradata Database. Used to keep the target table updated continuously … Read More
2013-07-06 09:43
A procedure or function is a schema object that consists of a set of SQL statements and other PL/SQL constructs, grouped together, stored in the database, and executed as a unit to solve a s… Read More
2013-07-04 09:22
Data modeling is a method used to define and analyze data requirements needed to support the business processes of an organization. The data requirements are recorded as a conceptual data mo… Read More
2013-07-01 09:48
Oracle's two major index types are Bitmap indexes and B-Tree indexes. B-Tree indexes are the regular type that OLTP systems make much use of, and bitmap indexes are a highly compressed index… Read More
2013-07-01 09:35
Simplify access to objects by creating a synonym (another name for an object). With synonyms, you can:• Ease referring to a table owned by another user• Shorten lengthy object name… Read More
2012-12-24 16:56
TPUMP is a flexible multi-session load utility.  The only characteristic of TPUMP that limits its use is its transaction oriented nature.  If the situation allows execution of Fast… Read More
2012-12-22 10:41
The syntax for the CREATE TABLE statement has been changed to permit user data tables to be created without a primary index. Such tables are referred to as NoPI (No Primary Index) tables.Thi… Read More
2012-12-12 15:55
It is possible to create functions which operate on large object data types. The following library functions exists to provide the ability use LOB's as function input or output:• FNC_Ge… Read More

Share the post

Teradata SQL Reference


Subscribe to Teradata Sql Reference

Get updates delivered right to your inbox!

Thank you for your subscription