| December 12, 2007 00:34:59 |
#9 |
| srinu_vasrao |
Member Since: December 2007 Total Comments: 1 |
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. |
| |
