How would we delete the data in change log table of ODS?
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 attr…these 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)?