SAP Interview Questions
Describe the nature of the relationship between SAP and D&B?
D&B and SAP have been Global Partners for over a year. D&B are mySAP.com Software Alliance Partners. The joint offering, D&B for SAP R/3, delivered as part of mySAP.com, seamlessly integrates the D&B for SAP R/3 solution and D&B business information for enhanced decision support. D&B also offers a Data Rationalization Service for SAP customers to consolidate, cleanse and eliminate redundant customer and vendor records that originate from a wide variety of sources and multiple formats.
--------------------------------------------------------------------------------
Is the relationship between D&B and SAP exclusive to either party?
No, the partnership agreement is not exclusive. It allows D&B to work with other application software providers and SAP to team with other content providers.
--------------------------------------------------------------------------------
What does the inclusion of D&B for SAP R/3 in mySAP Edition mean for customers?
Basically all mySAP Edition contract holders will automatically receive the D&B for SAP software as part of their regular Edition upgrade shipments. They will be able to install both A/R and A/P versions of the software as many times as they desire under the conditions of their SAP contract, without the need to obtain separate licences for the D&B Add-on. Do I have to have mySAP.com to be able to use D&B for SAP R/3? No, the software is available from SAP without the need to purchase or install mySAP.com.
--------------------------------------------------------------------------------
What are the benefits for SAP and D&B?
SAP differentiates itself from competitors by delivering software and content, which is increasingly becoming a customer focus. The unique combination of standardized software and standardized data that can be processed in R/3 is very attractive to customers.
--------------------------------------------------------------------------------
What is significant about online access in R/3 to D&B information?
The significance is that solution components allow customers real-time, direct access to business information that previously could not be accessed from within the R/3 software. Customers can now easily and efficiently access business information that they require to make certain decisions. When will the software component be available to mySAP Edition customers? It will be made available from June and all subsequent mySAP Editions.
--------------------------------------------------------------------------------
What kinds of companies (markets) are you targeting with D&B for SAP R/3?
Businesses in any industry that have customers and suppliers and have a high volume of transactions are ideal prospects. Do you have any customers using the software functionality today that we can talk to? There are over 60 customers using the service. A number of success stories are available from this Web site. Is this product/service available globally? A Global Access version of the product has been made available via a Software Support Package available via SAPNet. Is this partnership a new strategy for D&B and SAP respectively? Since the ERP market for software and services is estimated to be a $50 billion market by 2002 - establishing partnerships with companies like SAP is key to D&B's embed strategy and long-term growth. SAP is committed to broadening its offering based on customer needs and will continue to work with partners to enhance SAP software. What is Data Rationalization and Online Access? D&B's Data Rationalization Service cleans, updates and organizes a company's customer and vendor master data, making the transfer of legacy files easier. In a typical project, D&B will consolidate dozens of a company's legacy customer or vendor files containing tens of thousands of records. D&B will clean and scrub, merge and purge data until there is one file with one record for each company in a consistent record format. Online Access is the ability to access D&B data directly from D&B hosts from within the R/3 applications, either prior to creating a new Master records, or to update an existing record.
--------------------------------------------------------------------------------
What are the benefits in using D&B for SAP Solutions to mySAP.com customers?
Real-time, online access to D&Bs risk and financial information on more than 30 million businesses in the U.S. and Europe, 64 million globally via the Global Access version
D&B can help cleanse and update the information being transferred from legacy files during the implementation phase
Faster implementation
High-quality customer and vendor master files
Improved performance in R/3
Improved risk management
Faster and effective lower-cost credit/vendor decisions
D&B also contributes to a lower total cost of ownership for the customer
D&B's data and services can also be used to speed up data preparation during the implementation phase of an installation and ensure the customer has a high quality customer and vendor master file in mySAP.com
--------------------------------------------------------------------------------
What are the technical prerequisites for using D&B for mySAP.com?
Key prerequisites for the installation of the D&B software are that the SAP customer is using at least R/3 Release 3.1 or higher, and that the R/3 Financial Accounting application (incl. Credit Management module) has been implemented and is operational. It is also necessary that the communication server for SAP has been enabled and that connectivity is achieved between the customers R/3 and D&Bs LAN.
--------------------------------------------------------------------------------
Can the D&B Online Access software be customized?
D&B delivers a standard online service for R/3. If a customer wants to customize the software, D&B is willing to provide technical information to support the effort. All customization costs will be incurred by the customer.
--------------------------------------------------------------------------------
How secure is the existing data in SAP R/3?
Data is secure and kept completely confidential for customers that migrate legacy data to R/3 using the D&B Data Rationalization Service. D&B will not manipulate any existing data in R/3 or take any data from R/3.
--------------------------------------------------------------------------------
Who has access to view D&B information SAP R/3?
D&B information is visible from the Credit Management and Accounts Payable screens within the Financial Accounting application of R/3. However, since the information is stored in R/3, it is possible for other users such as sales and marketing associates to view it. However, the customer must configure the SAP security to allow such viewing.
--------------------------------------------------------------------------------
Who will provide technical support of the D&B services?
SAP will provide for the first-level support while D&B will handle the second-level support if required.
--------------------------------------------------------------------------------
Will the D&B product remain on SAP's global price list?
D&B is the first company to have its online access application D&B for SAP R/3 listed on SAPs global price list. The application will remain on SAP's price list for all non-Edition customers.
--------------------------------------------------------------------------------
What is the price of the D&B data?
Dun & Bradstreet has its own pricing models based on the volume of data purchased by customers.
Didn't D&B compete against SAP, providing client/server software a few years ago?
D&B Software, a former company of The Dun & Bradstreet Corporation, did develop and market client/server software. The company was sold to GEAC Computer Company in Toronto in 1996 when the corporation refocused its strategy on delivering content.
Is it difficult to install D&B for SAP R/3?
No, it is very easy. The whole process should take less than half a day. D&B provides in-depth documentation to assist in the installation process.
--------------------------------------------------------------------------------
How is the software delivered?
D&B for SAP R/3 software is delivered on separate CDs within the Edition shipment and contain a set of transport files that need to be installed in the R/3 system. These transport files are available for R/3 Release 3.1h and higher. The transport files configure an area on the database to hold the D&B data, as well as configuring the SAP software.
--------------------------------------------------------------------------------
How do upgrades work?
Upgrades work in a similar way to other SAP add-on solutions. When an upgrade takes place in R/3, the data remains in the R/3 database and D&B access needs to be upgraded (no repository switch upgrade).
What is data quality?
Within SAP, data quality is defined as postal validation, duplicate checking, and error tolerant searching. Postal Validation enhances address information by comparing data against address directories provided from local postal authorities around the world. Duplicate Check avoids duplicate entries by scanning the database for potential duplicates before new customer data is committed to the database. Finally, Error Tolerant Searching provides flexibility by giving users the ability to conveniently search their SAP system for business information as required. Involvement of a data quality initiative helps you maintain a reliable source of information for all departments within your own organization while simultaneously maximizing interactions with your vendors, customers, and business partners.
--------------------------------------------------------------------------------
When and where should I integrate data quality into my SAP Suite of applications or other projects in my enterprise?
Data quality should be integrated any place where data is entered, loaded, processed, or updated. Data quality should be built into the beginning phases of all Enterprise Resource Planning, Customer Relationship Management, and Business Intelligence projects. Too many projects focus on data quality as an afterthought, at the back-end of a data repository or when a project has failed. By not incorporating data quality measures at every customer touch point, on both front and back-end operations, the cost of cleansing the data dramatically increases as well as how long the cleansing process takes to complete.
--------------------------------------------------------------------------------
Can I integrate a data quality solution within other software applications?
Data quality solutions can be fully integrated into CRM, ETL (Extract Transform Load), ERP, or BI solutions and have the advantage of being "seamless" to the end user - reducing the learning curve, as well as decreasing the implementation timeframes. Your data process flow should not have to be modified to add a new data quality solution. Through integration and strategic partnerships you are assured that you are getting a best-of-breed solution. However, keep in mind it is not absolutely necessary for the solution to be fully integrated. Firstlogic also provides tools that your organization can easily integrate on your own, and oftentimes stand-alone solutions may be more effective for specific projects.
--------------------------------------------------------------------------------
Will Firstlogic's Global Data Quality Connector for SAP manage my international data?
Yes. Built on a global framework capable of validating address information for over 190 countries in a single processing pass, Firstlogic's Global Data Quality Connector for SAP allows you to identify country names, format and standardize addresses, correct missing address information, and assign postal codes for each respective country. Furthermore, Firstlogic's Easy IQ technology offers the ability to complete/populate addresses with minimal data or offer suggestions for possible matches. This easy address system is ideal in call centers or any transactional environment where data needs to be cleansed at the point-of-entry. The software improves real-time transactions for your call centers, sales, and support centers by providing accurate address data for your customer facing employees. How easy is it to maintain Firstlogic's Global Data Quality Connector for SAP after implementation? Ongoing maintenance should be minimal. Once the solution is implemented and configured, typically maintenance will only be required when you receive postal directory updates, upgrade to a new data quality release, or decide to change your application or business rules.
--------------------------------------------------------------------------------
What are the benefits of a data quality solution?
The biggest benefit is the confidence you have that your data is accurate. A data quality solution also allows you to:
Manage customer data in different formats initially residing in separate databases
Build and maintain successful relationships
Better understand and service your customers
Enhance knowledge management and business intelligence initiatives with reliable and accurate information
Deliver clean, reliable data throughout your expanding information supply chains to all varieties of operational and analytical applications throughout your enterprise
--------------------------------------------------------------------------------
How does Firstlogic's Global Data Quality Connector for SAP Systems work?
Firstlogic's Global Data Quality Connector is integrated at the BASIS layer and communicates with the SAP Applications via TCP/IP leveraging SAP's Remote Function Call (RFC) interface. As users make postal validation inquiries in either batch or real-time, calls are made outside of the SAP Application to Firstlogic's RFC Server. Once the customer's address has been received by Firstlogic's technology, our Information Quality Suite parses, standardizes, and corrects records according to configurable business rules and local postal authority standards. To ensure your customer view is optimized, Firstlogic's technology catches duplicates at the point of entry; not after redundant information has infected your SAP Environment. Before any customer, vendor, or business partner is committed to the database, Firstlogic's Information Quality suite will immediately inspect the data upon input. The connector scans the entire database for duplicates and assigns a similarity match score to potential duplicates. At that point, the user can determine whether the entered record is unique or a duplicate that should be eliminated from the system. In addition, convenient Error Tolerant Searching is available for prompt and precise address recognition. This improves transaction processing, saves time locating records, and optimizes system efficiency.
--------------------------------------------------------------------------------
Explain the architecture of Firstlogic's Global Data Quality Connector for SAP Systems.
Integrated at the BASIS/WAS layer, Firstlogic has developed Business Add-Ins (BAdI's) that can be leveraged with a single instantiation; allowing for all SAP modules that utilize SAP's Business Address Services framework to leverage the compelling advantages of Firstlogic technology. Furthermore, Firstlogic's Information Quality Suite has been developed as a Remote Function Call (RFC) Server: the most common integration component of SAP software. Utilizing SAP's RFC interface, SAP makes calls to Firstlogic technology for address check, updates, duplicate checks, and error tolerant searches.
SAP Interview Questions
Why does SAP support Linux?
SAP's goal is to be able to provide its customers the maximum of flexibility to create the best IT environment for their needs and be able to get the most value out of their business applications driving growth and profit. Openness, flexibility, and integrity of our products have always been part of our product strategy, putting customers in the position to decide what's best for their IT environment. So the main reason is to offer you a free choice. Many SAP customers want to use Intel hardware and at the same time use their Unix know-how. Linux is growing with incredible speed and absolutely meets the quality standards of SAP. And thanks to the platform-independent SAP architecture, the port of the SAP kernel was fairly easy: none of the SAP business applications had to be modified. Another reason is the number of Unix operating systems SAP has to support. Especially when you try to get maximum performance out of your hardware resources, there are significant differences between the different Unix flavours. SAP has to maintain, test and support each possible combination of OS, database, hardware and mySAP release. With Intel moving to 64 bit there is a high probability of even more Unix flavours. A consolidation of these Unix derivatives would benefit both vendors and customers. From our point of view Linux has a realistic chance to become the unified Unix running on different hardware platforms. If Open Source continues like this, it is very important for a software company to adapt early to the new situation. We are very proud that SAP was the first software in the world that run mission-critical ERP operations on Linux. We expect Linux to be successful in low and high end installations and SAP, as Trusted Adviser, is helping customers to make the right decisions around SAP on Linux.
--------------------------------------------------------------------------------
What is the SAP LinuxLab?
The SAP LinuxLab assists in the releasing of SAP software on Linux and drives the porting of SAP software to new platforms, like the Intel Itanium or IBM Power PC. Furthermore it helps other SAP departments with developing on and for the Linux platform and processes Linux-specific support problems - internal ones, as of external - or forwards them to the appropriate hardware or software partner. Currently, developers from Bull, Dell, Fujitsu-Siemens, HP, IBM, Intel, Novell/SUSE, RealTech, Red Hat, SAP, SUN and a number of temporary "guests" share the same rooms in the LinuxLab. Despite our hardware partners being competitors, the cooperation is excellent and we had a number of very successful projects. The LinuxLab also cloesely cooperates with (and is located directly next to) SAP's Server Infrastructure department, which is responsible for the development of the SAP kernel, the basis layers on top of the native operating systems, which make SAP's business applications platform independent.
--------------------------------------------------------------------------------
What role does SAP play in the Open Source scene?
We are supporting Open Source when it comes to Linux as an operating system or MaxDB (formerly Adabas/D or SAP DB) as a database. In fact, back in 1999, we were the first business software provider to support Linux as an operating system for running SAP solutions. We work closely with the Linux distributors and our partners to ensure our solutions work smoothly on Linux. Our main focus with SAP on Linux is helping our customers build the IT environment that is right for them. More and more customers are requesting help with SAP on Linux. And we are there to provide them with the high quality support they expect from SAP.
--------------------------------------------------------------------------------
Interested in offering your software to SAP customers so they can enhance functionality of their SAP servers running Linux?
SAP is open to third party software and hardware products. As SAP only uses standard APIs provided by the Linux OS, third party software is usually transparent to us. Whereas we usually do not certify third party software, LinuxLab is open for joint development efforts.
--------------------------------------------------------------------------------
What does "SAP NetWeaver on Linux" mean?
SAP is the market leader of inter-enterprise software solutions with the world's largest enterprise software customer base. SAP has more than 10 million licensed users, more than 20,000 installations in more than 100 countries and supports 28 different languages. More than half of the world's top 500 companies use SAP software!
SAP supports the mySAP Business Suite in a productive environment under Linux. This also includes the database server (IBM DB2/UDB, Informix, Oracle and SAP DB) as well as the application server and the frontend. You can run SAP on Linux in homogeneous and heterogeneous environments.
The mySAP Business Suite is running upon the SAP NetWeaver, which includes components like the SAP Web Application Server or the SAP Enterprise Portal. For a more detailed view on SAP NetWeaver please refer to http://www.sap.com/netweaver.
--------------------------------------------------------------------------------
Where can I get the mySAP Business Suite on Linux?
You can order the mySAP Business Suite on Linux just like mySAP software on any other platform. If you are a SAP customer already, there will be no additional charges. From Release 4.6 onwards, the mySAP Business Suite on Linux is part of the standard delivery.
--------------------------------------------------------------------------------
Where can I get Linux for mySAP Business Suite?
Linux distributors like Debian, Mandrake, Red Hat or SUSE offer Linux together with a set of other software packages, installation routines, documentation and support. Whereas there is a de facto standard for the Linux kernel itself, the distributions differ in other areas, especially in the administration area.
--------------------------------------------------------------------------------
Will pricing be changed for mySAP Business Suite on Linux?
Standard pricing for mySAP Business Suite applies also to mySAP Business Suite on Linux.
--------------------------------------------------------------------------------
What are the main reasons for SAP customers choosing Linux?
Each SAP customer has a unique set of reasons for running SAP on Linux, depending on the very specific customer's SAP scenario. Among many reasons customers decide for Linux as the operating system of choice, because they seek increased
Flexibility
Scalability with different sized commodity, or even large former Unix or mainframe systems
Freedom of choice for technology vendors
Replacing larger Unix-based SAP servers
--------------------------------------------------------------------------------
Where do I get support?
Support of SAP solutions on Linux meets the same high standards as for any other platforms. SAP is offering installation and migration tools and paths, and support staff trained for SAP on Linux matters. For porting and highly technical issues, SAP has the SAP LinuxLab, where hardware and software partners are working closely together to “bring you the best SAP on Linux experience".
Standard SAP support covers SAP related problems as on other platforms too. During message processing, if the problem turns out to be caused by a non-SAP part of the installation/system, it might become necessary to envolve further expertise, as of the hardware- or software partner and its support organisation. Therefore it is strongly recommended for SAP customers, running SAP software on the Linux platform, to maintain a support contract for both, hardware and operating system, so a seamless support process chain can be ensured.
Support for the operating system can either be covered directly by the vendor itself, like Red Hat or Novell/SUSE, or by a 3rd party company offering equivalent support, like all our Linux hardware partners do in combination with their products.
Our Linux hardware and our database partners provide the same degree of support for Linux with their products as they already do for the respective Unix - if the necessary support contracts are given. Red Hat and SUSE offer direct operating system support contracts as well.
Please get in contact with your hardware or software vendor for more information. This practice helps all involved parties to solve any possibly arising problem as fast as possible. If the support coverage is incomplete, it can lead to avoidable delayments in problem solving - and please keep in mind: extraordinary expenses by SAP or our partners, caused by missing support coverage, may get billed to the customer afterwards!
--------------------------------------------------------------------------------
Which releases of mySAP Business Suite are supported on Linux?
mySAP Business Suite on Linux is generally available for use in a productive environment starting with release 4.0B.
--------------------------------------------------------------------------------
Which databases are supported for mySAP Business Suite on Linux?
Supported databases for mySAP Business Suite on Linux are IBM DB2/UDB, Informix, Oracle and SAP DB/MaxDB.
--------------------------------------------------------------------------------
Will a customer get support when recompiling the Linux kernel or using 3rd-party software that modifies it?
Usually there should be no need for recompiling the Linux kernel when using SAP software on Linux, since the supported Linux distributors are shipping optimized kernels for the respective hardware architectures with revised and tested drivers. Any modification to the tested environment would furthermore make it nearly impossible for the Linux distributor to track a problem down. The same applies to 3rd party software that modifies the Linux kernel and is distributed only in a closed, binary-only, way. Therefore the following can't be supported:
Recompiling the Linux kernel, with or without source modifications
Loading of 3rd party binary Linux kernel modules which have not been shipped by the Linux distributors
Loading of any unsupported Linux kernel modules
Loading of any closed source drivers drivers
--------------------------------------------------------------------------------
Which server configurations of mySAP Business Suite will be supported on Linux?
SAP supports mySAP Business Suite on Linux for database and application servers in homogeneous and heterogeneous environments. Please get in contact with your hardware partner for system sizing and similar.
--------------------------------------------------------------------------------
Is Linux supported as a frontend platform?
The "SAPGUI for the Java Environment" can be downloaded from the SAP ftp servers. This project (formerly known as PlatinGUI - platform independent GUI) started in spring 1998 with the following objectives:
build one GUI for all platforms (MacOS, Linux, OS/2, Win32, AIX, HP/UX, Solaris, Tru64 ...)
provide Control-Enabling with Java Beans
create a new, flexible GUI-architecture
support web browser integration
1. What is ERP?
ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.
2. Different types of ERP?
SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERPs most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.
3. What is SAP?
SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.
4. Explain the concept of “Business Content” in SAP Business Information Warehouse?
Business Content is a pre-configured set of role and task-relevant information models based on consistent Metadata in the SAP Business Information Warehouse. Business Content provides selected roles within a company with the information they need to carry out their tasks. These information models essentially contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update rules and extractors for SAP R/3, mySAP.com Business Applications and other selected applications.
5. Why do you usually choose to implement SAP?
There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
6. Can BW run without a SAP R/3 implementation?
Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.
7. What is IDES?
International Demonstration and Education System. A sample application provided for faster learning and implementation.
8. What is WF and its importance?
Business Work Flow: Tool for automatic control and execution of cross-application processes. This involves coordinating the persons involved, the work steps required, the data, which needs to be processed (business objects). The main advantage is reduction in throughput times and the costs involved in managing business processes. Transparency and quality are enhanced by its use.
9. What is SAP R/3?
A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.
10. What are presentation, application and database servers in SAP R/3?
The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.
11. What should be the approach for writing a BDC program?
Convert the legacy system data to a flat file and convert flat file into internal table. Transfer the flat file into sap system called “sap data transfer”. Call transaction(Write the program explicitly) or create sessions (sessions are created and processed ,if success data will transfer).
12. Explain open SQL vs native SQL?
ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.
13. What are datasets?
The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.
14. What are internal tables check table, value table, and transparent table?
Internal table: It is a standard data type object, which exists only during the runtime of the program. Check table: Check table will be at field level checking. Value table: Value table will be at domain level checking ex: scarr table is check table for carrid. Transparent table: - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.
15. What are the major benefits of reporting with BW over R/3? Would it be sufficient just to Web-enable R/3 Reports?
Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end — now imagine that occurring even more frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.
16. How can an ERP such as SAP help a business owner learn more about how business operates?
In order to use an ERP system, a
business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates. Using SAP as a tool to learn about ERP systems will require that the
people understand the business processes and how they integrate.
17. What is the difference between OLAP and Data Mining?
OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting.
18. What is Extended Star Schema and how did it emerge?
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.
19. Define Meta data, Master data and Transaction data
Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data. Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies. Transaction data: Data relating to the day-to-day transactions is the Transaction data.
20. Name some drawbacks of SAP
Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.
21. What is Bex?
Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.
22. What are variables?
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.
23. What is AWB?. What is its purpose?
AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.
24. What is the significance of ODS in BIW?
An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.
25. What are the different types of source system?
SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.
26. What is Extractor?
Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.
No comments:
Post a Comment