Whereas the data flows loading the warehouse dimensions are first passed to a sort editor that removes any duplicated rows of data before being passed on to a slowly changing dimension adapter, flows that populate the fact tables are not first passed through a sort adapter before being passed on to a slowly changing dimension adapter. In the dimension load tasks, the fuzzy look up is used to lookup data rows with spelling mistakes and correct such mistakes. We transform Arabic column name to English name and then use the data conversion transformation tool that enables us to convert columns from one data type to another. Transformation means that map extracted data to the same format data for cancer data warehouse repository.
Before being loaded into the data warehouse, data extracted from the multiple sources was transformed using built-in transformations contained in SSIS. This development contains the following steps: In this step we extracted data from access database which are created in Arabic language from multiple tables such as "Patient, Procedure, Ticket and Visit" tables for transform and load in dimension and fact table. data warehouse is developed according to the previous star schema data model.
0 kommentar(er)
