Interested to Buy Any Domain ? << Click Here >> for more details...
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????
- 3 Answers
- 13308 Views
- Mphasis, I also Faced
- E-Mail Answers
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 |
Give a justifiable reason why Multi-load supports NUSI instead of USI.
what is identity column in TD?
Explain about Skew Factor?
Fast Load Script is failed and error tables are available then how do you restart?
Explain parsing engine in teradata?
suppose one Cylinder split data blocks are moved from where?
What are the things to be considered while creating secondary index?
How do you determine the number of sessions?
If RDBMS is halted what will you do ?
How to copy teradata scripts from ur remote desktop to server machine?
How do you Generate Sequence in Teradata?
What are the different functions performed in development phase?
Teradata 
