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 is called partitioned primary index (ppi)?

966

What is the function of parser component in teradata?

1047

What is the opening step in basic teradata query script?

995

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

948

What are the functions involved in shared information architecture?

1031

Explain parsing engine in teradata?

1036

how can we analyze the locks ?

2069

What are the newly developed features of Teradata?

977

What is teradata? What are some primary characteristics of teradata?

940

Describe primary index in teradata?

963

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

944

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2104

What are the joins in teradata and how many types of joins are there in teradata?

971

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

1047

Define views in teradata with general syntax.

991