期刊名称:Faculty of Computer Science and Information Technology
出版年度:2011
卷号:0
期号:0
语种:English
出版社:Faculty of Computer Science and Information Technology
摘要:The process of information management of human resources to handle all personnel transactions, ranging from data collection for new employees, employee turnover, vacation, violations, promotion, until the payroll in the amount of data requires a great deal of each month. Additionally, if a company has employees of more than 2000 people, of course, the search process the data to create a report will take a long time. Based on these reasons, the author tried to make a data-mart, which is expected to generate data in accordance with the desired criteria quickly and accurately. Data-mart is created using the facility DTS (Data Transformation Services) in SQL Server 2000, starting from the process of extraction, transformation, until the loading process. While the application to access the data mart is built with the programming language Visual Basic 6.0.