Question:
Difference between infocube and ODS?
Answer:
Infocube is structured as star schema(extended) where in a fact table is surrounded by different dim table which connects to sids. And the data wise, you will have aggregated data in the cubes. ODS is a flat structure(flat table) with no star schema concept and which will have granular data(detailed level). Source: CoolInterview.com
infocube haveing the extended starschema strucure and ODS have the flat structure.in the infocube u can maintain historical data. in ods u can maintain the detailed data or granular data.it has 3 tables those are active data table , changlog table, newdata table.in infocube it has only two table E, F fact tables. Source: CoolInterview.com
Answered by: venkat | Date: 4/11/2010
| Contact venkat
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|