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 / 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
What is difference between user and database in teradata?
What is partitioned primary index (ppi)?
Explain the term 'tables' related to relational database management system?
Steps to create a data model?
What is teradata?
How can we check the version of Teradata that we are using currently?
how can we analyze the locks ?
What is the difference between fastload and multiload?
What are the different functions included in the server software?
What are the functions involved in shared information architecture?
What are differences between teradata and ansi session modes in teradata?
Differentiate primary key and partition key?
how many modules are there in telecome domain?how to explain the architecture?
What type of indexing mechanism do we need to use for a typical data warehouse?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.