Sapient Previous Years Solved Sample Placement Papers
What is table partitioning and what are the benefits of partitioning in an InfoCube?
It is the method of dividing a table which would enable a quick reference. SAP uses fact file partitioning to improve performance. We can partition only at 0CALMONTH or 0FISCPER. Table partitioning helps to run the report faster as data is stored in the relevant partitions. Also, table maintenance becomes easier. Oracle, Informix, IBM DB2/390 supports table partitioning while SAP DB, Microsoft SQL Server, IBM DB2/400 do not support table partitioning.
How many extra partitions are created and why?
Two partitions are created for dates before the begin date and after the end date.
What are the options available in transfer rule?
- InfoObject
- Constant
- Routine
- Formula
How would you optimize the dimensions?
We should define as many dimensions as possible, and we have to ensure that no single dimension crosses more than 20% of the fact table size.
What are Conversion Routines for units and currencies in the update rule?
Using this option, we can write ABAP code for Units / Currencies conversion. If we enable this flag, then the unit of the Key Figure appears in the ABAP code as an additional parameter. For example, we can convert units from Pounds to Kilos.
Can an InfoObject be an InfoProvider, how and why?
Yes, when we want to report on Characteristics or Master Data. We have to right-click on the InfoArea and select "Insert characteristic as data target". For example, we can make 0CUSTOMER an InfoProvider and report on it.
What is Open Hub Service?
The Open Hub Service enables us to distribute data from an SAP BW system into external Data Marts, analytical applications, and other applications. We can ensure controlled distribution using several systems. The central object for exporting data is the InfoSpoke. We can define the source and the target object for the data. BW becomes a hub of an enterprise.
How do you transform Open Hub Data?
Using BADI, we can transform Open Hub Data according to the destination requirement.
What is ODS?
Operational DataSource (ODS) is used for the detailed storage of data. We can overwrite data in the ODS. The data is stored in transparent tables.
What are BW Statistics and what is its use?
They are a group of Business Content InfoCubes used to measure performance for Query and Load Monitoring. It also shows the usage of aggregates, OLAP, and Warehouse management.
What are the steps to extract data from R/3?
- Replicate DataSources
- Assign InfoSources
- Maintain Communication Structure and Transfer rules
- Create an InfoPackage
- Load Data
What are the delta options available when you load from a flat file?
The 3 options for Delta Management with Flat Files:
- Full Upload
- New Status for Changed records (ODS Object only)
- Additive Delta (ODS Object & InfoCube)