What are the different design perspectives used in teradata?
No Answer is Posted For this Question
Be the First to Post Answer
Why are oltp database designs not generally a good idea for a data warehouse?
Why do you get spool space errors? How do trouble-shoot them?
What do you mean by tpt in teradata?
What are aggregate tables? How do you design them using teradata?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
How does hashing happens in teradata?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
in 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
What are the string manipulation operators and functions associated with teradata?
How will you solve the problem that occurs during update?
What are the steps involved in the process flow of the sql statement through channel attached system?