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

Describe the set operators in teradata.

752

Explain parsing engine in teradata?

793

Different phases of multiload?

763

Explain teradata architecture in detail with a diagram.

828

What are the different table types supported by teradata?

708

What is called partitioned primary index (ppi)?

742

Write a program to show the parser component used in teradata?

729

How to Extract data from multiple legacy systems?

794

Can you connect multiload from ab initio?

884

How many types of joins are there in teradata?

715

In general, how do you optimze any sql in teradata?

762

What is the difference between teradata and oracle?

764

Explain PDE.

820

What are the available primary index types in teradata.

764

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4123