Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ansari
Fact table: It contains numeric values and also contain
composite key(i.e collection of foreign key) e.g.. sales
and profit.
Dimension table: It contains character values E.g
Customer_name,Customer_city.
| Is This Answer Correct ? | 48 Yes | 79 No |
Post New Answer View All Answers
What are the differences between star and snowflake schema?
What is normalization, first normal form, second normal form, third normal form?
What is meant by metadata in context of a data warehouse?
what is difference between drill & scope of analysis?
What is difference between query studio and report studio?
How to get the first 100 rows from the flat file into the target?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Name a few sectors which use data warehousing?
Explain what are the different types of join operations?
Explain what are necessary tasks to install reportnet software?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is Active Datawarehousing?
How to improve session performance in aggregator transformation?
What is Sequence clustering algorithm?
