How to handle nulls in Teradata???
How many columns can be there in a table???
How to find average sal with out using avg function????
Answers were Sorted based on User's Feedback
Answer / sri
without using "avg" we can find the avg salary by using sum
(sal)/count(sal);
sel sum(sal)/count(sal) as avgsal from tablename
regards,
sri
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / yuvaevergreen
1. Use zeroifnull,nullifzero in select and NULL in insert
directly.
2. 256 columns max per table.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / tdguy
1. use coalesce(column1,column2) or case when column1 is
nul...end or zeroifnull(column1) to handle nulls.
2. in TD 14.0 there can be 2048 columns per table.
3. sum/count gives you the average of the field.
Is This Answer Correct ? | 1 Yes | 0 No |
Can we collect statistics on table level?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
During the Display time, how is the sequence generated by Teradata?
how do you manage the production space. what are the proactive methods you can take ?
What is stored procedure in teradata?
what is the difference between filter and router transmissions
Can you connect multiload from ab initio?
On which column will you take primary index???
What are the components provided on node?
if a error occured in FASTLOAD is the fastload job stops?
What is multi insert?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD