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 do you mean by teradata intellicloud?

979

---

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

917

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

929

---

What interface is used to connect to windows based applications?

1039

---

What are the design features involved in teradata?

976

---

What is the purpose of indexes?

1012

---

What are the various indexes in teradata? How to use them? Why are they preferred?

1002

---

What are the things to be considered while creating secondary index?

1036

---

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

1118

---

In Teradata, what is the significance of UPSERT command?

1134

---

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

1036

---

Highlight the differences between Primary Key and Primary Index.

1018

---

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

1014

---

List out teradata data types?

958

---

If a Node is busy what are the steps you can take to avoid ?

2349

---