Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashok kumar lenak
Dimension Table-The tables through which i can under the
business.
It has wide range of rows.
It is called end dimension table.
It is joined to the Fact table.
Values are textural in nature.
Usually the Master tables are look like the Dimention table.
Fact Table-It is also called the Central table.
Most rows are numeric in nature.
Narrow rows and few columns.
It is accessed by the dimention table.
All the PK of the dimention table is at the fact table.
Usually the transaction tables look like the Fact Table.
| Is This Answer Correct ? | 29 Yes | 13 No |
Post New Answer View All Answers
What are the tools available for etl?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are the different types of schemas used in data warehousing?
What is incremintal loading?
What is the working process for application.cfm?
What is perform recovery?
Explain what is partitioning? What are the types of partitioning?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain what are fact, dimension, and measure?
What are the advantages of query studio compared to report studio?
What is data analysis? Where it will be used?
What are data modeling and data mining? Where it will be used?
What is index awareness in universe?
How to create diff. Types of templates?
