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

Difference between stored procedure and macro?

1125

---

Where is teradata rdbms used?

1050

---

What is bteq utility in teradata?

927

---

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?

2058

---

Highlight the need for Performance Tuning.

1049

---

What is real time and near real time data warehousing?

1076

---

What are the different design perspectives used in teradata?

945

---

Explain teradata utilities?

1000

---

What interface is used to connect to windows based applications?

1056

---

What is the purpose of upsert command?

1103

---

What is partitioned primary index (ppi)?

1016

---

Syntax for case when statement?

1020

---

Explain and compare pros and cons of snow flake schemas?

992

---

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

978

---

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

1109

---