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
- 11778 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is real time and near real time data warehousing?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is the purpose of upsert command?
What happens in a conflict? How do you handle that?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Explain vproc in teradata?
Why teradata is used?
What are some primary characteristics of teradata?
What do you mean by ttu in teradata?
Define views in teradata with syntax.
if collect stats but it show low confidence why?
What are the components used in smp and massively parallel processing (mpp) machines?
How would you load a very large file in teradata in general?
What are some commonly used bteq scripts?
Highlight the limitations of TPUMP Utility.
