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
- 13084 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
How to select first n records in teradata?
What are the available primary index types in teradata.
What is bteq script in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
Describe primary index in teradata. And what are the available primary index types?
What are some commonly used bteq scripts?
What are the design features involved in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the functions involved in shared information architecture?
What is a clique?
What is oltp?
What are the joins in teradata and how many types of joins are there in teradata?
What is teradata? What are some primary characteristics of teradata?
What are normalization, first normal form, second normal form and third normal form?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
