tailieunhanh - data warehousing architecture andimplementation phần 5

hoặc với văn hóa của doanh nghiệp. Công nghệ. Những rủi ro liên quan đến quy hoạch, lựa chọn, và sử dụng các công nghệ lưu kho. Rủi ro công nghệ cũng phát sinh từ môi trường máy tính hiện có, cũng như cách thức mà theo đó | Typical background interview questions arranged by categories for the IT department include Current architecture. What is the current technology architecture of the organization What kind of systems hardware DBMS network end-user tools development tools and data access tools are currently in use Source system relationships. Are the source systems related in any way Does one system provide information to another Are the systems integrated in any manner In cases where multiple systems each have customer and product records which one serves as the master copy Network facilities. Is it possible to use a single terminal or PC to access the different operational systems from all locations Data quality. How much cleaning scrubbing deduplication and integration do you suppose will be required What areas tables or fields in the source systems are currently known to have poor data quality Documentation. How much documentation is available for the source systems How accurate and up-to-date are these manuals and reference materials Try to obtain the following information whenever possible copies of manuals and reference documents database size batch window planned enhancements typical backup size backup scope and backup medium data scope of the system . important tables and fields system codes and their meanings and keys generation schemes. Possible extraction mechanisms. What extraction mechanisms are possible with this system What extraction mechanisms have you used before with this system What extraction mechanisms will not work Identify External Data Sources If Applicable The enterprise may also make use of external data sources to augment the data from internal source systems. Examples of external data that can be used are Data from credit agencies Zip code or mail code data Statistical or census data Data from industry organizations Data from publications and news agencies Although the use of external data presents opportunities for enriching the data warehouse it may