SAP BW Important Interview Questions Paper- Part - 12

Q) What does TEXT Table contain?Master text data, short text, long text, medium text & language key if it is language dependent

Q) What does Hierarchy table contain?Master hierarchy data

Q) What is the advantage of extended STAR Schema?
Q). Differences between STAR Schema & Extended Schema?A) In STAR SCHEMA, A FACT Table in center, surrounded by dimensional tables and the dimension tables contains of master data. In Extended Schema the dimension tables does not contain master data, instead they are stored in Masterdata tables divided into attributes, text & hierarchy. These Masterdata & dimensional tables are linked with each other with SID keys. Masterdata tables are independent of Infocube & reusability in other InfoCubes.

Q) As to where in BW do you go to add a character like a ; # so that BW will accept it. This is transaction data which loads fine in the PSA but not the data target.A) Check transaction SPRO ---Then click the "Goggles"-Button => Business

Information Warehouse => Global Settings => 2nd point in the list. I

hope you can use my "Guide" (my BW is in german, so i don't know all the english descriptions).

Q) Does data packets exits even if you don't enter the master data, (when created)?
Q) When are Dimension ID's created?A) When Transaction data is loaded into InfoCube.

Q) When are SID's generated?A) When Master data loaded into Master Tables (Attr, Text, Hierarchies).

Q) How would we delete the data in ODS?A) By request IDs, Selective deletion & change log entry deletion.

Q) How would we delete the data in change log table of ODS?A) Context menu of ODS â ' Manage â ' Environment â ' change log entries.

Q) What are the extra fields does PSA contain?A) (4) Record id, Data packet

Q) Partitioning possible for ODS?A) No, It's possible only for Cube.

Q) Why partitioning?A) For performance tuning.

Q) Have you ever tried to load data from 2 InfoPackages into one cube?A) Yes.
Q) Different types of Attributes?A) Navigational attribute, Display attributes, Time dependent attributes, Compounding attributes, Transitive attributes, Currency attributes.

Q) Transitive Attributes?A) Navigational attributes having nav attrthese nav attrs are called transitive attrs

Q) Navigational attribute?A) Are used for drill down reporting (RRI).

Q) Display attributes?A) You can show DISPLAY attributes in a report, which are used only for displaying.

Q) How does u recognize an attribute whether it is a display attribute or not?A) In Edit characteristics of char, on general tab checked as attribute only.

Q) Compounding attribute?A)?

Q) Time dependent attributes?A)?

Q) Currency attributes?A)?

Q) Authorization relevant object. Why authorization needed?A)?

Q) How do we convert Master data InfoObject to a Data target?A) InfoArea â ' Infoprovider (context menu) â ' Insert characteristic Data as DataTarget.

Q) How do we load the data if a FlatFile consists of both Master and Transaction data?A) Using Flexible update method while creating InfoSource.

Q) Steps in LIS are Extraction?A)

Q) Steps in LO are Extraction?A) * Maintain extract structures. (R/3)

* Maintain DataSources. (R/3)

* Replicate DataSource in BW.

* Assign InfoSources.

* Maintain communication structures/transfer rules.

* Maintain InfoCubes & Update rules.

* Activate extract structures. (R/3)

* Delete setup tables/setup extraction. (R/3)

* InfoPackage for the Delta initialization.

* Set-up periodic V3 update. (R/3)

* InfoPackage for Delta uploads.

Q) Steps in FlatFile Extraction?A) ?

Q) Different types in LO's?A) Direct Delta, Queued Delta, Serialized V3 update, Unserialized V3 Update.

Direct Delta: - With every document posted in R/3, the extraction data is transferred directly into the BW delta queue. Each document posting with delta extraction becomes exactly one LUW in the corresponding Delta queue.

Queued Delta: - The extraction data from the application is collected in extraction queue instead of as update data and can be transferred to the BW delta queue by an update collection run, as in the V3 update.