Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
IBM,
2109Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
1 4163Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
45 51001How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
2 6701in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
IBM,
1 5617
What are normalization, first normal form, second normal form and third normal form?
What is spool space?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain fallback in teradata?
How to eliminate product joins in a teradata sql query?
Explain and compare pros and cons of snow flake schemas?
How to Extract data from multiple legacy systems?
What are differences between teradata and ansi session modes in teradata?
What is the syntax for case when statement?
How many sessions of MAX is PE capable of handling at a particular time?
What is meant by a Highest Cost Plan?
Explain the term 'database' related to relational database management system?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Describe the set operators in teradata.
What are the enhanced features in teradata v2r5 and v2r6?