Data Warehouse Data Mart Interview Preparation Guide
Download PDF
Add New Question

Data Mart Frequently Asked Questions in various Data Warehouse Data Mart Interviews asked by the interviewer. So learn Data Mart with the help of this Data Warehouse Data Mart Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Data Warehouse Data Mart Interview Question or answer by the comment feature available on the page.

11 Data Mart Questions and Answers:

1 :: What is data mart?

Data Marts is used on a business division/department level.
A data mart only contains the required subject specific
data for local analysis.
A database, or collection of databases, designed to help
managers make strategic decisions about their business.
data marts are usually smaller and focus on a particular
subject or department. Some data marts, called dependent
data marts, are subsets of larger data warehouses. A data
mart is a simpler form of a data warehouse focused on a
single subject (or functional area) such as sales, finance,
marketing, HR etc. Data Mart represents data from single
business process.

Data mart is a subject oriented data base which support the business requirement of the indivisual business department.Data mart is a sub set of the Dataware house.Since it improves the perfomance of the Dataware house,it also known as High Performance Query Structure(HPQS).

Subject means Business of Interest like HR,Finance,Sales department etc
Post Your Answer

2 :: Explain What is data validation strategies for data mart validation after loading process?

Data validation is generally done manually in DWH in this case if source and TGT are relational you need to create SQL scripts to validate source and target data and if source is Flat file or non relational database you can use excel if data is very less or create dummy tables to validate your ETL code.
Post Your Answer

3 :: What is data validation strategies for data mart v?

Data validation strategies are often heavily influenced by the architecture for the application. If the application is already in production it will be significantly harder to build the optimal architecture than if the application is still in a design stage. If a system takes a typical architectural approach of providing common services then one common component can filter all input and output thus optimizing the rules and minimizing efforts.

There are three main models to think about when designing a data validation strategy.

*Accept Only Known Valid Data
*Reject Known Bad Data
*Sanitize Bad Data

We cannot emphasize strongly enough that Accept Only Known Valid Data is the best strategy. We do however recognize that this isn't always feasible for political financial or technical reasons and so we describe the other strategies as well.

All three methods must check:

*Data Type
Post Your Answer

4 :: What is the definitions for Datawarehose and Datamart?

Datamart is subset of Datawarehouse we can say a
datamart is collection of individual departmental
Where as datawarehouse in collection of datamart.

Data mart is a single subject and datawarehouse is a integration of multiple subjects
Post Your Answer

5 :: What is difference between drill & scope of analysis?

Drilling can be done in drill down, up, through, and across; scope is the overall view of the drill exercise.
Post Your Answer

6 :: Explain Meta data?

Metadata is data about data. E.g. if in data mart we are receiving any file. Then metadata will contain information like how many columns, file is fix width/limited, ordering of fields, data types of field etc.

Metadata is adata about data.meta data comes in picture when we need to knowabout how data is stored and where it is stored.metadata tool is helpfull in caputuring the business meta data and the following sections explain business metadata.metedata tools are using for gathering,storing,updating,and for retrieving the business and technical metadata of an org.
Post Your Answer

7 :: Explain What are Data Marts?

Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes complete individual data warehouses which are usually smaller than the corporate data warehouse.
Post Your Answer

8 :: Explain What is type 2 version dimension?

Version dimension is the SCD type II in real time it using because of it will maintain the current data and full historical data.

In scd type 2 we have flag, version and timestamp..Type 2 reveals about contain historical and current data.. Whenever the current data get's in version was change.. for eg: em id 1000 is staying in chennai it is v1, when his location changed to bangalore v2, again to delhi v3.. remember its only for em id 1000.
Post Your Answer

9 :: Explain difference between data ware house & data mart?

Data warehouse is made up of many datamarts. DWH contain many subject areas. However, data mart focuses on one subject area generally. E.g. If there will be DHW of bank then there can be one data mart for accounts, one for Loans etc. This is high-level definitions.
Post Your Answer

10 :: What we will do with the Universe for faster process?

For a faster process create aggregate tables and write better sql so that the process would fast.
Post Your Answer
Add New Question