![]() 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 Comments
Leave a Reply. |