Answer Posted / 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.

What is the dense rank?

1154

---

in sap bi we have wad, then why we go for sap bo

3343

---

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2224

---

Explain difference between zabo and webi?

1065

---

Explain what sort of existing documents should business analysts refer to when starting on a new project?

964

---

Explain about a task that really tested your analytical abilities?

1205

---

What is the difference between condition & filter?

1411

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1843

---

Explain how many universes can be created in a project?

1032

---

Can we configure two instances of CMS pointing to two different CMS system databases?

1985

---

what is document design in boxi,have u participate in that

2116

---

What is thumbnail?

932

---

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

979

---

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2296

---

When to use local filter and when to use global filter?

956

---