Answer Posted / vinay sir(datawarehousing tech

Guys,
First of all the question is not proper,it is supposed to
be "the difference between correlated sub queries and
simpe sub queries".

Corelated and Simple, both are Subqueries(having inner and
outer queries) but the way they execute is different.
Simple Subquery:Inner query executed first and then outer
query. Inner query executed only one time.

Corelated Sub query:Outer query is executed first and then
inner query.Outer query is executed many times.

Please find a common example where you can see the
execution difference.

Simple Subquery: select max(sal) from emp where sal not in
(select max(sal) from emp)
Corelated: Select a.sal from emp e where 1=(select count
(distinct(b.sal)) from emp b where a.sal<b.sal)

What are the design features involved in teradata?

1058

---

Write a program to show the parser component used in teradata?

977

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2202

---

What do you mean by teradata sql assistant?

1063

---

What are the different methods ot loading a dimension table? A fact table etc?

1036

---

How many tables can you join in v2r5?

1073

---

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?

1113

---

Highlight the differences between Primary Key and Primary Index.

1092

---

What are the frequently used data types in teradata?

1084

---

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

1080

---

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

1048

---

What happens when a node suffers a downfall?

1132

---

What are the updated features of teradata?

1046

---

What is teradata and why it is used?

1099

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154

---