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,
2038Hi 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 4083Does 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 49691How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
2 6578in 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 5513
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
If a Node is busy what are the steps you can take to avoid ?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are the various indexes in teradata? How to use them?
Explain the term 'foreign key' related to relational database management system?
How many sessions of MAX is PE capable of handling at a particular time?
What are the steps to create a data model?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are differences between teradata and ansi session modes in teradata?
What is meant by a Highest Cost Plan?
What is the multi-insert?
how do you manage the production space. what are the proactive methods you can take ?
Highlight the differences between Primary Key and Primary Index.
What are the string manipulation operators and functions associated with teradata?
if collect stats but it show low confidence why?