| The basic criteria for the formation of data | | | | like a several dimension table. Since the table is very |
| warehousing is to scrutinize data from diverse | | | | large, it is measured in the gigabyte. This table ensure |
| sources while taking decision-making. The objective | | | | with enormous useful data. The dimension table size |
| of data warehousing is to scrutinize data from | | | | will amount to 1 to 5 percent of the actual table size. |
| diverse sources to support decision making. | | | | This table does not require any normalization. |
| Poor Performance | | | | ETTLExtracting, Transferring, Transforming, and |
| Generally, data warehouse refers to storage of | | | | Loading Data |
| numerous data in it. It is not a quick process to | | | | One finds difficult while designing database, because |
| retrieve data from the data warehouse for analysis | | | | building a data warehouse involve a significant task |
| purposes. To scrutinize the data, this data warehouse | | | | that do not arise OLTP system. It is difficult to |
| design uses a special process known as star schema. | | | | extract, transform, transfer and load the data from |
| One finds difficult while extracting, transferring, | | | | the diverse source to data warehouse. |
| transforming and loading data from diverse sources | | | | ETTL Process |
| into a data warehouse. The Data must be analyzed | | | | While extracting the data, data has been transferred |
| properly before using. For the failures of many data | | | | from the source system such as sap R/3 system. |
| warehousing projects ETTL has been frequently | | | | The purpose of this extraction is to identify the right |
| quoted. You also realize the problem if you started | | | | data. A knowledgeable source system is essential for |
| analyzing the data without SAP BW. | | | | absolute accomplishment. |
| Today in large companies, SAP R/3 is used for | | | | In transfer, we transfer a large number of data from |
| management purposes. This SAP R/3 which is an | | | | different source systems to the data warehouse. |
| enterprise resources planning system which is used | | | | Here the purpose is to plan a reasonable schedule |
| business purposes. Before the introduction of the | | | | and should have reliable and fast networks. |
| SAP BW, SAP R/3 was mainly used by the data | | | | In data transformation, we design data to represent |
| warehouse. SAP BW is a business information | | | | consistently in the data warehouse. The original data |
| warehouse which explains the needs of the business | | | | which exist in different databases may use different |
| development. To mark your success in the market | | | | data types or different file formats. Some are case |
| competition, you have to complete with the | | | | sensitive; others may not be. |
| up-to-date development of your business | | | | In loading, we load data the actual tables |
| environment. These challenges enable the business to | | | | appropriately and quickly. The purpose is to develop a |
| take an appropriate decision with the available data. | | | | complete procedure. |
| This decision enables you to make many successes in | | | | This ETTL is a complex and time-consuming task. |
| your business life. | | | | Any error in it will put in to a risk at data quality, will |
| Basic Concept of Data Warehousing | | | | affect business decision making. Due to this reason |
| Data warehouse is a system, which contains its own | | | | many data warehousing projects will try to complete |
| database. This data warehouse collects data from | | | | their work in time. |
| various sources and it is planned to support while | | | | SAP R/3 is a good business functionality which leads |
| research has been taken place. For the purpose of | | | | to a complex database. Actually, it contains |
| analytical processing a special database technique | | | | approximately 10,000 database tables. Sometimes the |
| called star schema is used. | | | | tables and columns may not have precise English |
| Star Schema | | | | descriptions. For years, due to the usage of SAP R/3 |
| Star schema is a new technique that is used by the | | | | data for decision making, the business people face a |
| business people for few years. This star schema has | | | | continuous problem. After short listing the problem, |
| various concepts in it. Star schema is used for the | | | | SAP decided to develop a new data warehousing |
| data base by the following method. | | | | solution to help its users. The result they found is |
| This star schema is a graphical version. The name has | | | | SAP Business Information Warehouse, or BW. |
| been derived since it looks like a star. The table looks | | | | |