Answer Posted / asitesh sinha

Please send to me all the dumps : asit.teradata@gmail.com.

Thanks in advance:)

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2044

---

how can we analyze the locks ?

2061

---

How can bottlenecks be identified?

958

---

What is called partitioned primary index (ppi)?

962

---

What are the various reporting tools in the market?

991

---

What is upsert statement in teradata?

1056

---

What is meant by a Least Cost Plan?

1007

---

how do you manage the production space. what are the proactive methods you can take ?

1884

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1045

---

What are the steps to create a data model?

986

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

984

---

Explain Teradata performance tuning and optimization?

1108

---

What are the various etl tools in the market?

1019

---

List out teradata data types?

962

---

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

2135

---