Explain what are data marts?
- 1 Answers
- 1255 Views
- I also Faced
- E-Mail Answers
Answer / Anshika Khanna
Data marts are smaller, more focused subsets of a data warehouse. They are designed to support specific business areas or departments by providing them with the relevant data they need for analysis and reporting. Data marts usually contain summarized and pre-aggregated data, making querying faster and more efficient compared to accessing raw data from the main data warehouse.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are Fact tables and Dimension Tables?
Why fact table is in a normal form?
What are the advantages of query studio compared to report studio?
Fact table is in normalized or de-normalized form?
what is parallelism?
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
Explain what are components of reportnet?
How can you implement many relations in star schema model?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is surrogate key? Where we use it?
What are aggregate tables and aggregate fact tables?
What is an OLAP (On-line Analytical processing) system?
Teradata 
