1. Use zeroifnull,nullifzero in select and NULL in insert directly. 2. 25

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????

Question Posted / yuvaevergreen

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

Please Help Members By Posting Answers For Below Questions

What are the steps involved after the disk manager passes the request?

1178

What are differences between teradata and ansi session modes in teradata?

1213

How can bottlenecks be identified?

1057

What interface is used to connect to windows based applications?

1167

Explain the term 'row' related to relational database management system?

997

Explain BYNET.

1051

List out teradata data types?

1060

Why are oltp database designs not generally a good idea for a data warehouse?

1102

What is meant by a Highest Cost Plan?

1109

Can we collect statistics on multiple columns?

1119

What is a node in teradata?

1046

any one answer me how they can analyzing the project using data ware housing?

2519

What is teradata?

1232

What are the things to be considered while creating secondary index?

1140

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1821