Answer / Parvez Adeeb

Some primary characteristics of Teradata are:
1. Scalabilityn- Teradata supports large volumes of data and high concurrency.
2. Performancen- Teradata is known for its high query performance due to its unique architecture.
3. Fault Tolerancen- Teradata has multiple redundant systems in place to ensure high availability.
4. Integration Capabilitiesn- Teradata can easily integrate with various data sources and applications.

What is a pseudo key? What is its use???

2 Answers   Mphasis,

---

What is a level of granularity of a fact table?

1 Answers  

---

Explain the meaning of Amp?

1 Answers  

---

In general, how do you optimze any sql in teradata?

1 Answers  

---

How many sessions of MAX is PE capable of handling at a particular time?

1 Answers  

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

How do you eliminate duplicates?

3 Answers  

---

Explain teradata utilities. What is multiload, fast load, tpump?

1 Answers  

---

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

3 Answers  

---

What is the diffrence between Multiload & Fastload interms of Performance?

8 Answers   Cap Gemini, Intel,

---

What are default access rights in teradata?

1 Answers  

---

What's the difference between timestamp (0) and timestamp (6)?

1 Answers  

---