Data Warehousing and Sap Bw
- Date: 2006-11-27 - Word Count: 677
Share This!
The basic criteria for the formation of data warehousing is to scrutinize data from diverse sources while taking decision-making. The objective of data warehousing is to scrutinize data from diverse sources to support decision making.
Poor Performance
Generally, data warehouse refers to storage of numerous data in it. It is not a quick process to retrieve data from the data warehouse for analysis purposes. To scrutinize the data, this data warehouse design uses a special process known as star schema. One finds difficult while extracting, transferring, transforming and loading data from diverse sources into a data warehouse. The Data must be analyzed properly before using. For the failures of many data warehousing projects ETTL has been frequently quoted. You also realize the problem if you started analyzing the data without SAP BW.
Today in large companies, SAP R/3 is used for management purposes. This SAP R/3 which is an enterprise resources planning system which is used business purposes. Before the introduction of the SAP BW, SAP R/3 was mainly used by the data warehouse. SAP BW is a business information warehouse which explains the needs of the business development. To mark your success in the market competition, you have to complete with the up-to-date development of your business environment. These challenges enable the business to take an appropriate decision with the available data. This decision enables you to make many successes in your business life.
Basic Concept of Data Warehousing
Data warehouse is a system, which contains its own database. This data warehouse collects data from various sources and it is planned to support while research has been taken place. For the purpose of analytical processing a special database technique called star schema is used.
Star Schema
Star schema is a new technique that is used by the business people for few years. This star schema has various concepts in it. Star schema is used for the data base by the following method.
This star schema is a graphical version. The name has been derived since it looks like a star. The table looks like a several dimension table. Since the table is very large, it is measured in the gigabyte. This table ensure with enormous useful data. The dimension table size will amount to 1 to 5 percent of the actual table size. This table does not require any normalization.
ETTLExtracting, Transferring, Transforming, and Loading Data
One finds difficult while designing database, because building a data warehouse involve a significant task that do not arise OLTP system. It is difficult to extract, transform, transfer and load the data from the diverse source to data warehouse.
ETTL Process
While extracting the data, data has been transferred from the source system such as sap R/3 system. The purpose of this extraction is to identify the right data. A knowledgeable source system is essential for absolute accomplishment.
In transfer, we transfer a large number of data from different source systems to the data warehouse. Here the purpose is to plan a reasonable schedule and should have reliable and fast networks.
In data transformation, we design data to represent consistently in the data warehouse. The original data which exist in different databases may use different data types or different file formats. Some are case sensitive; others may not be.
In loading, we load data the actual tables appropriately and quickly. The purpose is to develop a complete procedure.
This ETTL is a complex and time-consuming task. Any error in it will put in to a risk at data quality, will affect business decision making. Due to this reason many data warehousing projects will try to complete their work in time.
SAP R/3 is a good business functionality which leads to a complex database. Actually, it contains approximately 10,000 database tables. Sometimes the tables and columns may not have precise English descriptions. For years, due to the usage of SAP R/3 data for decision making, the business people face a continuous problem. After short listing the problem, SAP decided to develop a new data warehousing solution to help its users. The result they found is SAP Business Information Warehouse, or BW.
Poor Performance
Generally, data warehouse refers to storage of numerous data in it. It is not a quick process to retrieve data from the data warehouse for analysis purposes. To scrutinize the data, this data warehouse design uses a special process known as star schema. One finds difficult while extracting, transferring, transforming and loading data from diverse sources into a data warehouse. The Data must be analyzed properly before using. For the failures of many data warehousing projects ETTL has been frequently quoted. You also realize the problem if you started analyzing the data without SAP BW.
Today in large companies, SAP R/3 is used for management purposes. This SAP R/3 which is an enterprise resources planning system which is used business purposes. Before the introduction of the SAP BW, SAP R/3 was mainly used by the data warehouse. SAP BW is a business information warehouse which explains the needs of the business development. To mark your success in the market competition, you have to complete with the up-to-date development of your business environment. These challenges enable the business to take an appropriate decision with the available data. This decision enables you to make many successes in your business life.
Basic Concept of Data Warehousing
Data warehouse is a system, which contains its own database. This data warehouse collects data from various sources and it is planned to support while research has been taken place. For the purpose of analytical processing a special database technique called star schema is used.
Star Schema
Star schema is a new technique that is used by the business people for few years. This star schema has various concepts in it. Star schema is used for the data base by the following method.
This star schema is a graphical version. The name has been derived since it looks like a star. The table looks like a several dimension table. Since the table is very large, it is measured in the gigabyte. This table ensure with enormous useful data. The dimension table size will amount to 1 to 5 percent of the actual table size. This table does not require any normalization.
ETTLExtracting, Transferring, Transforming, and Loading Data
One finds difficult while designing database, because building a data warehouse involve a significant task that do not arise OLTP system. It is difficult to extract, transform, transfer and load the data from the diverse source to data warehouse.
ETTL Process
While extracting the data, data has been transferred from the source system such as sap R/3 system. The purpose of this extraction is to identify the right data. A knowledgeable source system is essential for absolute accomplishment.
In transfer, we transfer a large number of data from different source systems to the data warehouse. Here the purpose is to plan a reasonable schedule and should have reliable and fast networks.
In data transformation, we design data to represent consistently in the data warehouse. The original data which exist in different databases may use different data types or different file formats. Some are case sensitive; others may not be.
In loading, we load data the actual tables appropriately and quickly. The purpose is to develop a complete procedure.
This ETTL is a complex and time-consuming task. Any error in it will put in to a risk at data quality, will affect business decision making. Due to this reason many data warehousing projects will try to complete their work in time.
SAP R/3 is a good business functionality which leads to a complex database. Actually, it contains approximately 10,000 database tables. Sometimes the tables and columns may not have precise English descriptions. For years, due to the usage of SAP R/3 data for decision making, the business people face a continuous problem. After short listing the problem, SAP decided to develop a new data warehousing solution to help its users. The result they found is SAP Business Information Warehouse, or BW.
Related Tags: sap jobs search, sap recruitment, sap jobs, sap news, sap forums, sap information, sap consultants
Ron Victor is a SEO copywriter for We buy homes cash.He written many articles in various topics like Sell your house fast. For more information visit We buy home fast .Contact him at ron.seocopywriter@gmail.com
Your Article Search Directory : Find in ArticlesRecent articles in this category:
- Ideas For Finding a Nanny Job
Looking after the welfare of children is a very important job. The role of caregivers in the present - What There is to Know About a Temp Agency
A temp agency is a place were skilled office workers can go to get work. There are a number of diffe - Discovering the Many Ways a Temp Agency Can Assist in a Down Economy
When out of money and unable to find work, often times can look hopeless. However, for many who have - Careers That Require Financial Responsibility
Keeping your finances in order is important for any adult, but if you want to work in certain career - What You Need To Know About Resumes And Cover Letters
If the ways of getting employed is composed of steps, the first task would be to come up with an imp - How To Increase Your Chances Of Getting Hired
In trying to get a job, the person that you are going to impress, aside from your would-be boss, wou - Tips on How to Get Hired in a Flash
Unemployment rate all over the world is undeniably huge. But, the bigger problem that professionals - Tips and Techniques on Finding a Job Quickly
There are three ways on how you can get employed at the soonest possible time- that would be, knowin - Securing Your Lifetime Starts Now
If by the time you're 30 and you still don't know what you want to do with your life, it should alre - Occupational Therapy Jobs For a Career in Nursing
Occupational therapy jobs are undertaken by individuals who are willing to engage their skills in he
Most viewed articles in this category:
- Hollow Eyes Are Not Dark Circles Under The Eyes
Many people of all ages complain of dark circles under their eyes. The phrase "dark circles under th - Career As A Hairstylist
Hairdressing is an art that involves arranging hair for aesthetic purposes, participation in formal - Life After West Point Military School
West Point exists to educate and train Cadets who are commissioned as Officers in the US Army upon G - Work Experience In Fashion - How To Get A Great Opportunity In Fashion Work
Work experience in fashion can be one of the most challenging positions to find. It's a simple equa - Tips for Job Hunting in Today's Market
In order to be competitive in today's job market, you must stand apart from the competition. Just h - Who are the EMTs
You'll find them at Denny's. At least I always do. Denny's, Coco's, Perkin's; any all-night restaura - Hiring A New Assistant?
More and more small businesses and even larger companies are turning to virtual office assista - You Too Can Start an Independent Record Label
It's no big secret, the trick of how to start a record label definitely involves some cash and most - Increased Salary with a Medical Degree: Consider the Options
Physicians are probably one of the highest paid professionals in the world. They make a lot of money - 5 Steps to Becoming a Virtual Assistant
Here are 5 steps that I went through in becoming a virtual assistant. These aren’t official by