Answer Posted / ronak

You have to use LPAD function,

Select lpad(address,20,'101')
from tableName;


NOTE: address is column name of address info, 20 is total
characters you want to display including 101 (since in this
case we don't know the characters of address),

Thank you
Ronak

Highlight a few of the important components of Teradata?

1025

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

1004

---

What are the functions of a teradata dba?

1070

---

What are the frequently used data types in teradata?

1076

---

What are the available primary index types?

1208

---

Explain and compare pros and cons of start schemas?

1061

---

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

1178

---

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

1049

---

What is smp and mpp platforms?

968

---

What do you mean by ttu in teradata?

1031

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2113

---

What do you mean by tpt in teradata?

1019

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1016

---

What is multi insert?

1045

---

How do you set the session mode parameters in bteq?

1102

---