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;

What does sleep function does in fast load?

1142

---

Explain fallback in teradata?

1065

---

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

1015

---

Highlight a few of the advantages that ETL tools have over Teradata.

1090

---

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

1153

---

What is meant by a node?

1041

---

Describe primary index in teradata?

1000

---

What is the use of having index on table?

1004

---

What do you mean by tpt in teradata?

1021

---

Define views in teradata with syntax.

1078

---

What happens in a conflict? How do you handle that?

1048

---

What is bteq utility in teradata?

977

---

Explain and compare pros and cons of snow flake schemas?

1035

---

How do you see a ddl for an existing table?

1018

---

Which is more efficient group by or distinct to find duplicates?

1090

---