Interested to Buy Any Domain ? << Click Here >> for more details...
which table we load first in DW. dimension or fact? why?
- 4 Answers
- 8078 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / adnan
Fact table has foreign keys referencing the primary key of dimension.
Logically Foreign key is a subset of primary or unique key. That's why , we
need to load dimension tables first and then to load fact tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What are the other methods working as deployment functionality?
what is the difference between native sql and cognos sql?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is the function of model design accelerator?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
difference between impromptu and cognos8
What you mean by drill across?
how you create security to reports?
What is the report studio?
How can create users and permissions in cognos?
What are the advantages of shortcuts?
What is a Cube?
what is catalog and types of catalogs in cagnos and which is better?
