Answer / g.v

Primary key as all of u know this is a unique key,surrogate
key is a non -intelligent key which is used to replace a
composite key


we are going for surrogate key bcz suppose a person is
living in one city and then moved to other and the person
id is a primarykey.we need to update the location then we
need to add the updated record but the primary key wont
accept to add the record again for this purpose we will go
for surrogate key

Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,

---

What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....

4 Answers  

---

I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?

1 Answers   Facebook,

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

How many number of cubes can we create on a single model? How can we navigate between those cubes?

2 Answers  

---

---

What is called materialized view?

0 Answers  

---

Difference between Express authoring mode and Professional authoring mode?

2 Answers   Wipro,

---

New coloums are added in database, then how you know in report level

0 Answers   Accenture,

---

advantages of cascade prompt ???

7 Answers   iFlex, Oracle,

---

how to handle multifact?

2 Answers   IBM,

---

WHAT ARE THE TYPES OF LIST REPORTS?

4 Answers   Patni,

---

How can we create a dynamic column name in cognos?

0 Answers  

---