Answer / tdguy

Sometimes, we may need aggregated data using some no of
columns from a very big table and these results are needed
in multiple sql requests In those cases, temporary tables
come in to picture and hold these temporary results for
further processing. When you need the table to be used
across sessions, GTT would be used so that definition would
be retained and can be reused by multiple users. When there
is a need only within the session, volatile table would be
used. These tables also help in speedy running of sqls.

Answer / yuvaevergreen

A volatile table is dropped at the end of the session(both
definition and data). It is stored in spool space and
statistics for the data cannot be collected. A global
temporary table's data alone is dropped at the end of the
session. It is stored in temp space and stats can be
collected. Any user can make use of the definition within
his temp space.

Answer / frank

Pls explain clearly don't understand

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  

---

What is a clique?

0 Answers  

---

which join mostly use in realtime?

2 Answers   TCS,

---

where we can use the delimiter in mload? pls let me know

2 Answers   Wipro,

---

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

0 Answers  

---

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

0 Answers  

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

0 Answers  

---

How to find duplicates in a table?

0 Answers  

---

what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,

---

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

---

how can i answer for question like teradat architecture in interveiw

4 Answers   TCS,

---

In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,

---