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????
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
Highlight the differences between Primary Key and Primary Index.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is meant by a Channel Driver?
What is the purpose of indexes?
What are the different functions performed in development phase?
Explain some differences between mpp and smp?
What is the purpose of using case expression in teradata?
What is spool space? Why do you get spool space errors?
how do you manage the production space. what are the proactive methods you can take ?
Where is teradata rdbms used?
Comment whether bottleneck is an error or not.
What is difference between user and database in teradata?
What is meant by Teradata Gateway?
When tpump is used instead of multiload?
How is MLOAD Client System restarted after execution?