Answer Posted / pavan

sel (case
when position('1' in name)>0 then substring(name from position('1' in name) for 1)
when position('2' in name)>0 then substring(name from position('2' in name) for 1)
when position('3' in name)>0 then substring(name from position('3' in name) for 1)
when position('4' in name)>0 then substring(name from position('4' in name) for 1)
when position('5' in name)>0 then substring(name from position('5' in name) for 1)
when position('6' in name)>0 then substring(name from position('6' in name) for 1)
when position('7' in name)>0 then substring(name from position('7' in name) for 1)
when position('8' in name)>0 then substring(name from position('8' in name) for 1)
when position('9' in name)>0 then substring(name from position('9' in name) for 1)
when position('0' in name)>0 then substring(name from position('0' in name) for 1)
else substring(name from 0 for 1)
end),name from ttemp.t2sel (case
when position('1' in name)>0 then substring(name from position('1' in name) for 1)
when position('2' in name)>0 then substring(name from position('2' in name) for 1)
when position('3' in name)>0 then substring(name from position('3' in name) for 1)
when position('4' in name)>0 then substring(name from position('4' in name) for 1)
when position('5' in name)>0 then substring(name from position('5' in name) for 1)
when position('6' in name)>0 then substring(name from position('6' in name) for 1)
when position('7' in name)>0 then substring(name from position('7' in name) for 1)
when position('8' in name)>0 then substring(name from position('8' in name) for 1)
when position('9' in name)>0 then substring(name from position('9' in name) for 1)
when position('0' in name)>0 then substring(name from position('0' in name) for 1)
else substring(name from 0 for 1)
end),name from ttemp.t2;

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1149

---

What is smp and mpp platforms?

959

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1150

---

What is a dimension table?

1038

---

What are the available primary index types?

1202

---

What are the various reporting tools in the market?

1039

---

What are differences between teradata and ansi session modes in teradata?

1155

---

If a Node is busy what are the steps you can take to avoid ?

2400

---

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

999

---

What is meant by a Clique?

1044

---

What do you mean by caching in teradata?

1039

---

Explain how spool space is used.

1061

---

How will you solve the problem that occurs during update?

1039

---

What is primary index and secondary index?

1013

---

Is multi insert ansi standard?

2188

---