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;

How do you define Teradata?

984

---

What happens when a node suffers a downfall?

1058

---

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

1095

---

Can we collect statistics on table level?

990

---

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

940

---

Describe the between keyword in teradata?

981

---

How does hashing happens in teradata?

1019

---

Explain the term 'columns' related to relational database management system?

991

---

How do you determine the number of sessions?

1010

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1062

---

What is spool space? Why do you get spool space errors?

949

---

How do you verify a complicated sql?

1014

---

What do you mean by fastexport in teradata?

941

---

What are the frequently used data types in teradata?

1006

---

In the Primary Index, what is the score of AMPs that are actively involved?

997

---