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
- 13310 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
Describe the set operators in teradata.
Why managing the data is important?
What are the steps involved in the process flow of the sql statement through channel attached system?
How to find duplicates in a table?
What are the functions involved in shared information architecture?
Describe primary index in teradata. And what are the available primary index types?
Explain vproc in teradata?
What are the things to be considered while creating secondary index?
How many types of joins are there in teradata?
What are the different functions included in the server software?
What is real time and near real time data warehousing?
What are the updated features of teradata?
What is logical data model?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is a node in teradata? Explain
