1: What is System session and Variables in the Repository
2: Explain about Security Levels in Siebel Analytics
3: What is OLAP and OLTP ?
3: Explain in detail about the Life cycle DWH
4: Whats are Views ( Narrative, Static, View Selector, Compound layout, charts and other Views)
5: What is the difference between Table and why Pivot Table View ?
6: What is SRMW Siebel Data Warehouse (W_PARAM_G needs to be populated always for any ETL run or all the SIL mappings will fail.
7: What are Aliases in Siebel Analytics Physical Layer
8: Explain Creation of Reports, Prompts and filters
9: What are the Advantages and Disadvantages of using SQl in Physical Layer ?
10: How is XLs Sheet imported in Physical Layer and its use
11: What is Online and Offline mode in Repository
12: How is Navigation done in Siebel Analytics if column is selected from two same sources in the Logical Layer
13: View and synonym where to use which scenarios in the Physical layer of the RPD
14: Whats are Triggers in Oracle
15: Can CASE statements used in Physical and Logical Layer ( IF Case and Switch CASE)
16:What are Groups and Web Groups, Groubs thats created in WEb will it visible in RPD
17: Explain Customization of Login Page ( style sheets and XML Files)
18: What is the use of a web server in Siebel analytics ?
19: What is Full and Incremental Load in SA ETL
20: What is DB Growth and size of the Database after ETL
21: How is mapping of new aggregate Table achievednin the Business Layer
22: How to have a new column in siebel naswers if the column is not avalible in Metadata
23: What is DAC and ETL
24: Explain in brief about Informatica, Siebel Applications Configuration and Siebel Tools and how are they related?
25: What is a Multiuser check out & Administration of RPDS.
26:Explain OBIEE Security & Single Sign on
27: Explain about the Visiblity Model in Siebel & OBIEE Analytics
28: What is the function of Connection Pool in the physical layer
29: Explain different user authentication methods available in Siebel Analytic s
30: Explain about Siebel Analytics column selector whats it it and how it can be used
31: How are Servers installed after your Installation of siebel Analytics
32: What are Action Links in siebel application
33: How does Siebel delivers Automatic population of Devices and profiles for users