0 votes
in Informatica by
What the difference is between a database, a data warehouse and a data mart?

1 Answer

0 votes
by

Database includes a set of sensibly affiliated data which is normally small in size as compared to data warehouse. While in data warehouse there are assortments of all sorts of data and data is taken out only according to the customer's needs. On the other hand datamart is also a set of data which is designed to cater the needs of different domains. For instance an organization having different chunk of data for its different departments i.e. sales, finance, marketing etc.

Related questions

0 votes
asked Dec 13, 2020 in DBMS by SakshiSharma
0 votes
0 votes
asked Feb 26, 2023 in Informatica by rajeshsharma
...