Answer / karthik

parlla distribution:
This is the key concept of Teradata storing data in parallel, as it uses PI to store data, data is is stored parallel across the AMP's available.

Sub table: This table is created when a Unique secondary Index is created on the table, it will have rowid,data and hash value for the data. It is used to fetch the data using secondary index.

Answer / yuvaevergreen

Parallel distribution: TD stores the data uniformly. Ideally, every amp should have equal no of rows from each table in vdisks.Based on the primary index, the distribution of data would be uniform on amps.

Sub table: It is used for secondary indexes and stored in amp(s).

Answer / tdguy

Parallel distribution - Due to "shared nothing"
architecture, TD distributes and fetches the data in
parallel. Mainly because of AMP,PE and BYNET.
Subtables - These are created and used by TD, when the
secondary indexes come into picture.

What is use of compress in terdata?Explain?

11 Answers  

---

Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,

---

Difference between multiload and tpump?

0 Answers  

---

What is the opening step in basic teradata query script?

0 Answers  

---

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

0 Answers  

---

What is the use of teradata system software?

0 Answers  

---

Explain PDE.

0 Answers  

---

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

---

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---

If the table does not have duplicates then which utility you can suggest to load the data ?

3 Answers  

---