This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

Teradata

//Teradata

Teradata Performance Analysis Tips

By | January 15th, 2013|Database, Teradata|

Scenario:                    This Article is prepared to understand the key points required to be considered while analyzing/improving the Teradata ETL performance. These points generally refer to the periodic activities or the housekeeping activities that should be done periodically to avoid the database performance implications. Key Points: Stat Collection Pack Disk Data Skew Analysis Lock monitoring [...]

Teradata – Stored Procedure Access Rights

By | January 15th, 2013|Teradata|

Introduction Teradata has a very unique way of handling stored procedures on its platform. It requires special privileges for hosting and execution. This document has been developed to understand the access rights requirements for stored procedures. It becomes complex to control access rights on teradata when dealing with too many WITH GRANT OPTION accesses as [...]

Historical data load from Teradata

By | August 19th, 2012|Database, Teradata|

This document describes the steps used to load the historical data load from Teradata into any target systems. Steps Involved: Step 1: Create temp table in tmp_work_db in Teradata Production using the sql Create tmp_work_db.<table_name> as (select * from <schema_name>.<table_name>) with no data; Hint: Better to create this table in Teradata Development for faster creation [...]

Creating a Teradata Database

By | June 8th, 2011|Database, Teradata|

Teradata Database: A Teradata database is a defined logical repository for: Tables Views Macros Triggers Stored Procedures Attributes that may be specified for a database: Perm Space - maximum amount of space available for tables Spool Space - maximum amount of work space available for requests Temp Space - maximum amount of temporary table space [...]

Teradata System Architecture

By | June 6th, 2011|Database, Teradata|

Teradata Version 1 Platforms: Teradata Version 1 was a combination of hardware and software.   For example, if a customer needed additional Parsing Engine capability, the hardware and software components for a “Parsing Engine” had to be purchased, installed, and configured. Platform Year Available Upper Limit CPUs Teradata DBC/1012 1984 1 TB 286, 386, 486 [...]

Teradata Performance analysis tips

By | June 6th, 2011|Database, Teradata|

  This article is prepared to understand the key points required to be considered while analyzing/improving the Teradata ETL performance. These points generally refer to the periodic activities or the housekeeping activities that should be done periodically to avoid the database performance implications. Key Points: Stat Collection Pack Disk Data Skew Analysis Lock monitoring (Locking [...]

Teradata RDBMS Architecture

By | June 5th, 2011|Database, Teradata|

Teradata is the software that makes a MPP system appear to be a single system to users and administrators.               The two major components of the Teradata RBDMS are implemented as virtual processors (vproc). Parsing Engine (PE) Access Module Processor (AMP) The MPL (PDE and BYNET) connects multiple nodes [...]

How Large is a Trillion?

By | May 31st, 2011|Database, Teradata|

1 Kilobyte = 103 = 1000 bytes 1 Megabyte = 106 = 1,000,000 bytes 1 Gigabyte = 109 = 1,000,000,000 bytes 1 Terabyte = 1012 = 1,000,000,000,000 bytes 1 Petabyte = 1015 = 1,000,000,000,000,000 bytes 1 million seconds = 11.57 days 1 billion seconds = 31.6 years 1 trillion seconds = 31,688 years 1 million [...]

Teradata BTEQ utility

By | May 27th, 2011|Database, Teradata|

Today we will discuss about Teradata Data utility BTEQ DEFINITION : BTEQ - Basic Teradata Query General-purpose, command-based program that allows users on a workstation to communicate with one or more Teradata Database systems. A set of SQL statements used to inserts updates or deletes in teradata tables. Imports data to teradata database from a file. Exports data from [...]