Above answers are correct, but data type should be taken care of.

write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?

Question Posted / tdguy

Answer Posted / tdguy

Above answers are correct, but data type should be taken
care of.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1159

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

823

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1095

What do you mean by ttu in teradata?

1031

What do you mean by teradata sql assistant?

1051

What is upsert statement in teradata?

1122

What are the available primary index types in teradata.

1028

any one answer me how they can analyzing the project using data ware housing?

2468

How is MLOAD Client System restarted after execution?

1139

What is the command in bteq to check for session settings ?

1178

What is the basic syntax for teradata select statement?

1031

Which is more efficient group by or distinct to find duplicates?

1083

Differentiate primary key and partition key?

979

What do you mean by tpt in teradata?

1019

What are the different softwares used with their functions in teradata?

1012