Tell me one example for multi valued dimension or bridge
table?
- 2 Answers
- 17782 Views
- Accenture, CMC, IBM, Logica CMG, TCS, I also Faced
- E-Mail Answers
Answer Posted / jenny
Bridge table is good when you have to change Many-to-Many
relationshipes to two one-to-many relationships.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Explain what are the advantages and disadvantages of reporting directly against the database?
What is the very basic difference between data warehouse and operational databases?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
Explain what are the advantages of query studio compared to report studio?
Explain bus schema?
What is surrogate key? Where we use it? Explain with examples.
What is type 2 version dimension?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Which are the olap tools available that are supported by oracle?
what is user variable in affinium campaign? and some real time examples.
How do you define data block size?
Why null values are mapped as 0 in fact tables?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What are loops in Datawarehousing?
What is the advantages data mining over traditional approaches?
