We are researching Specifically with business users in mind and accordingly presenting some information On Data Staging which is ; Getting data out of source systems and into the data warehouse in reasonable and rational format is by far the largest effort of building data warehouse. This activity can account for 80% of the total efforts of the total project. The issues are not so much technical as business. Understanding how different systems represent data, settling on a common format, and determining just who owns the data, consume the time.
Data staging is typically done through process called ETL ( Extract- Transform-Load). There are many tools available in the market today to automate this process, and selection of a tool that meets the needs of the organization should be not undertaken lightly. The replacement of an ETL tool can run millions of dollars for even a moderately sied organization because of the need to re-engineer and extensively test the process that are touched by ETL process.
Source: Certified Management Accounting – Information Technology ( topic)







