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 functions performed by bynet?

1035

Explain vproc in teradata?

991

Highlight a few of the advantages that ETL tools have over Teradata.

1084

What are the functions of a teradata dba?

1070

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

939

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

1060

What are some commonly used bteq scripts?

1003

What are types of partition primary index (ppi) in teradata?

1043

What is the difference between teradata and oracle?

1017

How do you create tables? Exact syntax, and create profiles, users in teradata?

1020

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1146

What are the available join types in teradata?

1064

Describe primary index in teradata. And what are the available primary index types?

996

When tpump is used instead of multiload?

1093

How do you set the session mode parameters in bteq?

1095