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
- 12489 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 |
What is a pseudo key? What is its use???
Explain teradata architecture?
what is object level locking ? where do appear this type of locking ?
In Teradata, what is the significance of UPSERT command?
if a error occured in FASTLOAD is the fastload job stops?
What is partitioned primary index (ppi)?
What are the steps to create a data model?
How a Referential integrity is handled in Teradata?
Aborted in Phase 2 data acquistion completed in fastload?
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 different table types that are supported by teradata?
Does SDLC changes when you use Teradata instead of Oracle?
Teradata 
