Define views in teradata with general syntax.

0 Answers  

---

How to relege locks in fastload and multiload? example?

4 Answers   IBM,

---

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

---

which option is used to restart the fast load script?

2 Answers  

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

0 Answers  

---

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?

0 Answers   IBM,

---

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

0 Answers  

---

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

2 Answers   Mphasis,

---

What is the syntax for case when statement?

0 Answers  

---

If table have access lock.In the same table write lock is posible or not?

1 Answers  

---

What are the available primary index types?

0 Answers  

---

Why are oltp database designs not generally a good idea for a data warehouse?

0 Answers  

---