Can master data change???if yes then how it'll
change.....please explain with example......
thanx
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the dense rank?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How to restrict password to a user while sending a document in .pdf format
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What is the difference between slice and dice and cross tab report?
what is xcelsius architecture?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is difference between webi and infoview?
What is Indexing? how did u implement indexing?
Explain what is the difference between slice and dice and cross tab report?
Did you face any problems while creating reports? Name? Solutions?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What Is Snow Flake Schema?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?