Explain is fact table?
Answer / Ravi Kumar Shukla
In data warehousing, a Fact Table stores measures or facts about the business entities. Each row in a fact table represents an event and contains foreign keys that link to corresponding dimensions (descriptive attributes) in dimension tables. Fact tables usually have a primary key composed of multiple columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are components of reportnet?
Explain some of modeling tools available in the market?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is informatica architecture?
what is the difference between etl tool and olap tools
How does data mining and data warehousing work together?
What is the difference between view filter and report filter?
What is called dimensional modelling?
How much data hold in one universe.
Explain what is the limit to the number of sources and targets you can have in a mapping?
Explain the definition of normalized and denormalized view and what are the differences between them?
Is there any default username & pwd for bo designer & supervisor?