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;

Explain fallback in teradata?

1105

---

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

1233

---

What is a node in teradata?

1050

---

Mention a few of the ETL tools that come under Teradata.

1131

---

Highlight the differences between Primary Key and Primary Index.

1145

---

How to load specific no.of records using bteq, or fastload,or multiload

1816

---

Can we collect statistics on table level?

1093

---

What is a three-tier data warehouse?

1155

---

Explain the most common data types used in teradata?

1125

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1084

---

Syntax for case when statement?

1118

---

What is meant by a Least Cost Plan?

1107

---

if collect stats but it show low confidence why?

1750

---

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

1000

---

What do you mean by teradata sql assistant?

1115

---