Answer Posted / har

Referential Integrity is handled using MultiLoad
It supports both soft referential Integrity(i.e degenerated dimension) and NUSI dataloading

In Teradata, what is the significance of UPSERT command?

1134

---

What is the meaning of Caching in Teradata?

1082

---

What are different table types used in teradata?

981

---

Explain the parallel data extension in teradata?

1027

---

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

1002

---

What are the enhanced features in teradata v2r5 and v2r6?

1079

---

How do you verify a complicated sql?

1014

---

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

980

---

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

1059

---

what are the uses of fact table and dimension table in banking project?

4494

---

Discuss the advantages of using partitioned primary index in a query?

909

---

Can we collect statistics on multiple columns?

988

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2135

---

Differentiate database data and data warehouse data?

1056

---

What is meant by a Virtual Disk?

1048

---