Q.What are the advanchages of archiving?Ans.To minimize space, query performance, load performance.
Q.What technology is used in BW archiving?Ans.ADK Archive Development kit.
Q.What is the archival transaction?Ans.SARA
Q.What are the size parameters archiving?Ans. a. Max size in M byte
b. Max no of data objects.
Q.What is the precaution you should take when archiving?Ans. When you archive info cube or OD S it is locked for any loads till the delete is finished; you should make sure that you archive and delete before you load any new data.
Q.what is the difference between restoring the cube Vs. ODS from archiving files?Ans.You can restore to ODS directly from SARA reanaction; for cube you should schedule an info package.
Q.Give step by step approach to archiving cube?Ans.
a. double click on the cube ( right click and select change)
b.Extras →select archival
c. Choose fields for selection(like 0CALDAY,0CUSTOMER etc.,)
d. Define file structure ( max file size and max no of data objects)
e. Select the folder ( logical file name)
f. Select the delete options(not scheduled, start automatically or
after event)
g. activate the cube
h. now cube is ready for archival.
Microsoft Technologies,Sap-Modules,Java,IBM-MainFrames,Siebel,Testing,DataBase,PHP, Bpo,Callcenter and Freshers Interview Questions.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment