RE: 1).briefly state different between data ware house...
1) Dataware house is made up of many datamarts. DWH contain many subject areas. but 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.
3) Metadata is data about data. e.g. if in data mart we are receving any file. then metadata will contain information like how many columns, file is fix width/elimted, ordering of fileds, dataypes of field etc..
RE: 1).briefly state different between data ware house...
datawarehouse: intergrated,relevant data(subject oriented) from different sources are put together to a data base for business decisions. these data is appended as time goes by keeping historical data (of a certain time period). this kind of a db is a datawarehouse..( u have to imagine a big concern). this warehouse will have data about the entire business.
datamart : its like a datawarehouse for a particular department. hence they contain data relating to that dept only.
u can bring data from these sources thru native drives or other methods and clean the data(profile, analyse etc) transform them if needed and load to the dw.
meta data is data about data...eg this is wer the data is , col def of the table, it contains primitive data types etc..
RE: 1).briefly state different between data ware house & data mart?2).How are u going to consolidate customer infromation in dataware house from the three different back end OLTP applications?3).What is meta data?
1) Data warehouse is a collection of datamarts. Where data marts contains the data about the single module. The data of all the datamarts(all the modules data) is data warehousing.
2) By an ETL transformations we can consolidate the customer information in data warehouse from three backend PLTP applications or flat files or any database files.
3) Metadata is data about the data...i.e., Metadata is about controlling the quality of data entering the data stream.
RE: 1).briefly state different between data ware house & data mart?2).How are u going to consolidate customer infromation in dataware house from the three different back end OLTP applications?3).What is meta data?
1. Data Mart is a Subset of Datawarehouse, In an Companies Different Dept Reffered as Datamart Ex; Accounts, Management, Training...etc
2. A Collection Of Datamart is Called Datawarehouse.
3. Data About the Data or Information About the Data is Called Metadata.
