As we have discussed so far, it is clear that most enterprises build data warehouse using the data available within the internal source systems. Besides available internally in the organization, this data is structured and has been configured in a regular format.
However, we could sometimes encounter chunks of data that is useful for the organization but not available within. This data is termed as External data in the warehouse, which is found unstructured and in unpredictable format. It is always advised to store such external data in the data warehouse as it could be helpful for business analysis and operations. If it isn’t stored in DWH, several problems arise.
External data in data warehouse
There are primarily two types of external data
Problems with external data
Several issues that arise due to the use and storage of external data are-
Looking for top jobs in Business Intelligence ? This blog post gives you all the information you need!
Metadata and External Data
Metadata in a warehouse plays a major role when any external data is identified.
Metadata provides users to determine information about the external data. There is another type of data associated with metadata – notification data, which alerts and notifies users about the data they are interested in the form of a file. When the external data enters the data warehouse and in the metadata, a check is placed to see who is interested in that external one. The system notifies that persona and then the external data is captured in the warehouse.
Storing the External Data
Archiving External Data
Since every information after certain time becomes uninteresting and is not worth keeping. Similarly, external data must be archived by deciding the useful lifetime of the data. However, we still face the dilemma whether that external data needs to removed or archived. The rule says that the external data must be removed from the warehouse and stored in less-expensive storage files. Consequently, the metadata reference to external data is also updated to indicate the new storage area, and thus, it is left there in the metadata.
One of the most meaningful actions attempted on external data is comparing it with internal data over a period of time. This comparison will enable business people to gain insights into unique components, which could never be possible without otherwise. For instance, you can compare personal activities and trends with the global trends. Mostly, this comparison is done on a common key.
Storing external data in DWH provides some relevant information that is available outside the company and helps businesses to run and update their enterprise processes accordingly.
Learn more about Business Intelligence in this insightful blog now!Previous Next
Download Interview Questions asked by top MNCs in 2019?