Answer / vidya

Yes in general we divide the data for ER modeling as master
and detail(transaction) data.

Master data will always be normalized in OLTP system, this
data need changes over course of time not often.

Example: Employee Database
Scenario: Change of Address,Location,active or inactive...

Warehouse is brought into picture only to denormalize these
data using keys concept

Same Example: Employee Database
Scenario: how many visits to onsite has the employee made
for the past 1 year.

how to create metric universe ?

0 Answers   TCS,

---

How to link one location universe to other location universe

3 Answers   Cap Gemini, TCS,

---

What is the difference between the Webintelligence and desktopintelligence?

2 Answers   IBM,

---

Difference between Object varification and validation

1 Answers   Cognizant,

---

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,

---

---

HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  

---

in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level

3 Answers   Accenture,

---

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 Answers  

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

---

In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,

---

how to optimize the query perfomance in b.o?

1 Answers   TCS,

---

What are the join problems comes appart from loop,chasm & fan Traps

0 Answers   IBM,

---