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

/Tag: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 [...]

Using Roles in Teradata

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

Today we will learn using roles in teradata with examples: Create roles. CREATE ROLE Inquiry_HR; CREATE ROLE Update_HR; CREATE ROLE Inquiry_Payroll; CREATE ROLE Update_Payroll; CREATE ROLE Batch_HR_Pay; Assign access rights to the roles (partial listing). GRANT SELECT, EXECUTE   ON HR_VM TO Inquiry_HR; GRANT INSERT, UPDATE, DELETE   ON HR_VM TO Update_HR; Grant users permission to use the roles. GRANT Inquiry_HR   TO Update_HR;   /*nested role*/ [...]

Teradata — Roles and Profiles

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

With Teradata V2R5, two new administration/security features are introduced - roles and profiles.  Roles and profiles simplify the management of users and access rights. What is a “role”? A role is simply a collection of access rights. –Rights are first granted to a role and the right to use the role is then granted to [...]

Teradata Multiple Choice Questions

By | May 6th, 2011|Database, Interview Questions, Teradata|

1. What are the following object required for Teradata Database-Prem space?. a) Tables & Stored Procedure b) Tables & Views c) Macros & Triggers d) Views & Stored Procedures Answer: a. 2. Global Temporary Tables are stored in the TD are a) Perm Space b) Spool Space c) Temp Space Answer : c 3. Terabytes [...]