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
- 12482 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is collect statistics?
What is meant by a Parsing Engine?
Which is more efficient group by or distinct to find duplicates?
What is inner join and outer join?
Explain vproc in teradata?
What are the frequently used data types in teradata?
Differentiate primary key and partition key?
What are the string manipulation operators and functions associated with teradata?
What is spool space? Why do you get spool space errors?
What are the steps to create a data model?
What is a three-tier data warehouse?
What is upsert statement in teradata?
Explain the term 'columns' related to relational database management system?
Explain teradata architecture?
What is dimensional modeling?
