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

Answers were Sorted based on User's Feedback



How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average..

Answer / sri

without using "avg" we can find the avg salary by using sum
(sal)/count(sal);

sel sum(sal)/count(sal) as avgsal from tablename

regards,
sri

Is This Answer Correct ?    9 Yes 0 No

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average..

Answer / 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

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average..

Answer / tdguy

1. use coalesce(column1,column2) or case when column1 is
nul...end or zeroifnull(column1) to handle nulls.
2. in TD 14.0 there can be 2048 columns per table.
3. sum/count gives you the average of the field.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

Can we collect statistics on table level?

0 Answers  


How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,


During the Display time, how is the sequence generated by Teradata?

0 Answers  


how do you manage the production space. what are the proactive methods you can take ?

0 Answers  


What is stored procedure in teradata?

0 Answers  


what is the difference between filter and router transmissions

2 Answers  


Can you connect multiload from ab initio?

0 Answers  


On which column will you take primary index???

4 Answers  


What are the components provided on node?

0 Answers  


if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,


What is multi insert?

0 Answers  


Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,


Categories