InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
As You Said You Have Worked On Info Cubes And Ods, Which One Is Better Suited For Reporting? Explain And What Are The Drawbacks And Benefits Of Each One? |
|
Answer» Depending on the type of REPORT the data is stored in Info Cube or ODS. BW is used to store high VOLUMES of data and faster reporting. Info Cube is used to store normalized data. Master Data and TRANSACTION data are stored in Info Cube as per the Extended Star Schema USING SIDs. The reporting is fast. ODS stores data in more detail utilizing its structure of transparent tables. Reporting on this will be SLOW. ODS is better used for RRI. Depending on the type of report the data is stored in Info Cube or ODS. BW is used to store high volumes of data and faster reporting. Info Cube is used to store normalized data. Master Data and transaction data are stored in Info Cube as per the Extended Star Schema using SIDs. The reporting is fast. ODS stores data in more detail utilizing its structure of transparent tables. Reporting on this will be slow. ODS is better used for RRI. |
|