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
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Whether dimension table can have numeric value?
How to limit the max no of rows retrieved in the report?
What is data stream and data adaopter. Is it same are different? Explain?
What is the difference between ods and oltp?
Explain what is ods (operation data source)?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain a mapping, session, worklet, workflow, mapplet?
Explain what are non-additive facts in detail?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What is the metadata extension?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is conformed fact?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Ist the schema that a data warehouse system can implements.
