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 commands to make a new table, change a table and remove a table in teradata?

1064

Explain the advantages of partitioned primary index in a query?

972

How to select first n records in teradata?

1039

Explain amp in teradata?

1002

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

1022

Can we collect statistics on table level?

985

Explain and compare pros and cons of start schemas?

973

What is dimensional modeling?

1010

What are the uses of bynets in multi-node systems?

967

What is meant by a Least Cost Plan?

1002

What is the opening step in basic teradata query script?

976

List the logical and conditional operators that are used with teradata along with their meanings?

938

What are aggregate tables? How do you design them using teradata?

1091

What are the various indexes in teradata? Why are they preferred?

955

why use references rather than pointers in the public api, particularly for arguments which are modified?

936