1: Explain Siebel Analytics Architecture ( Infrastructure & Applications)
2: What are the different Components in Siebel Analytics.Explain about BI Server, Delivers Server, BI Web, BI Cluster, Open Intelligence Interface.
3: What is Caching.Explain the different types of caching like Query , Web Server, Seed Cache, Siebel Analytic Server Cache.
4: Explain Siebel Analytics Metadata Administration (Physical Layer, Logical Layer,Presentation Layer )
5: Explain in detail about Build, Deploy and Generating Requests (Answers, Interactive Dashboards, Delivers, Web Catalog
6: What are Informatica Mapping Tables?
7: Explain Integration of OBIEE with siebel CRM applications
8: What are Marketing Segmentation ( segment, Segment tree,List Catalog, List Import,Target Levels and Target List)
9: Explain in detail about the SQL Joins like INNER JOINs, OUTER JOINs, CROSS JOINs. How many ways OUTER JOINs are further classified?
10: How to view more than 10000 records in Siebel Analytics web in a Table or Pivot table Views.
11: What is a Bridge Table ( many to Many Relationship in dimension.) Implemenation in Siebel Analytics
12: How can objects can be Imported in Physical Layer( tables, views, Aliases, synonyms, system Tables, Keys, Fk Keys)
13: Explain what do you mean by Dimension Hierarchy ( Drill Key and Level Key, Prefered drill Path)
14: What are Business Model Complex Joins (Place holder) and hardcode foriegn key
15: Explain Physical model Connection Pool (shared Logon and Maximum connections and FIFO)
16: Explain about Shared logon in Physical layer of the RPD how it works and whats the use of it
17: What are Global Prompt and Filters, Filter( is Prompted) in SA 7.5.3
18: What are Dashboard Objects ( content, reports,section, Page , Dashboard and Folder)
19: What is a Admin page ( Sessions, Priviliges, Analytics Catalog, Web Groups and uses)
20: How do you do Performacne Tunining in Siebel Analytics ( hints and Nl,)
21: What is Event Polling ( how event polling is done and also Purging)
22: What are SDE and SIL Mappings ( Siebel data warehouse ETL, SRMW)
23: What are Slowly changing Dimension ( type1, Type2, type3)
24: What is a Assocative Entity ( Data Modelling)
25: Explain truncate and Delete ( Auto commit on truncate)
26: What are the different types of indexes in Oracle ( B* , B tree, clustered)
27: Explain Plan and TK Prof ( Tunning)
29: What is Aggreagte Navigation, Fragmentation, Intialization Blocks and Variables ()
30: What is a Star and Snow flake Schema
31: Explain about SRMW Tables (Fact tables ,Dim Tables, mini Dim Tables, Subset dim Tables,
32: What are Circular Join, Factless Fact