SAP BW Important Interview Questions Paper- Part - 14

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)?

No comments:

Post a Comment