fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

can you give me the syntax of named procedure??

2 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

How would you design a database for an online site, which would average a million hits a day?

0 Answers  

---

How can you log an error to the server event log from a stored procedure?

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

0 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

How can you fix a poorly performing query?

0 Answers  

---

Write the difference between case version and decode version.

2 Answers  

---