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
- 13291 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 meant by a Virtual Disk?
Explain the term 'row' related to relational database management system?
How many types of joins are there in teradata?
Name the five phases that come under MultiLoad Utility.
What is the use of fallback?
Explain the term 'foreign key' related to relational database management system?
What is the basic syntax for teradata select statement?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Describe the set operators in teradata.
What exactly do you know about catching in teradata?
What are the design features involved in teradata?
How is MLOAD Teradata Server restarted after execution?
what is object level locking ? where do appear this type of locking ?
How can we check the version of Teradata that we are using currently?
