Answer Posted / hari m

Hi Vennala

The posted query will work fine. But what if incase 'N'
no.of columns, like address1, address2..., address n.

The query will become lenghty with N no.of Unions.

Is there any script or procedure as alternative??

Please help me out in this regard.

Thanks,
Hari

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1750

---

Explain and compare pros and cons of start schemas?

1076

---

Define views in teradata with syntax.

1085

---

Can you fastexport a field, which is primary key by putting equality on that key?

1181

---

How to view every column and the columns contained in indexes in teradata?

1058

---

Discuss the advantages of using partitioned primary index in a query?

962

---

Explain teradata architecture?

1101

---

List out some of the primary characteristics of teradata.

1018

---

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

1170

---

What is a sparse index?

1092

---

What happens when a node suffers a downfall?

1141

---

What are the various etl tools in the market?

1075

---

What are some commonly used bteq scripts?

1022

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1210

---

Which is faster fastload or multiload?

1124

---