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
- 11747 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri
without using "avg" we can find the avg salary by using sum
(sal)/count(sal);
sel sum(sal)/count(sal) as avgsal from tablename
regards,
sri
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
Answer / 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 |
How can bottlenecks be identified?
Explain fallback in teradata?
What is a common data source for the central enterprise data warehouse?
Highlight the need for Performance Tuning.
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?
Why do you get spool space errors? How do trouble-shoot them?
What is spool space?
How many types of joins are there in teradata?
What's the syntax of sub string?
What are the differences between TerdataV2R5 and V12 Versions please??
Explain the meaning of Amp?
I want to write one query How to get Matched records and unmatched records in table?
Teradata 
