Wednesday, 14 January 2015

Implement custom styles for Tables used in Answers/Dashboard using Narrative view

Using HTML styling in narrative view we can create customized tables.



  • Tables with custom size, shape, background color, which can meet certain client requirements can be created.
  • It improves the look and feel of the reports.
  • For example, it can be used to match the skin and theme of currently existing Client portals.

Sample Code:


<style type="text/css">
table.tftable {font-size:15px;color:#333333;width:100%;border-width: 1px;border-color: #729ea5;border-collapse: collapse;}
table.tftable th {font-size:15px;background-color:#77AFEF;border-width: 1px;padding: 8px;border-style: solid;border-color: #729ea5;text-align:left;}
table.tftable tr {background-color:#EDF3FA;}
table.tftable td {font-size:13px;border-width: 1px;padding: 8px;border-style: solid;border-color: #729ea5;}
</style>
<table id="tfhover" class="tftable" border="1">
<col width="200"><col width="200"><col width="200">
<tr><th colspan="2">Activity ID</td><td colspan="3">[b]@1[/b]</th></tr>
<tr><td>[b]Activity Type[/b]</td><td>@2</td><td>[b]Logon:[/b] @3</td></tr>
<tr><td>[b]Employee[/b]</td><td>@4</td><td>[b]Status :[/b] @5</td></tr>
<tr><td>[b]Comments[/b]</td><td>@6</td><td>[b]Desc :[/b] @7</td></tr>
[br/]
</table> 

OBIEE MCQ

1-      Which of them is/are not OBIEE Services to be started?
a)      Java Host
b)      Server
c)       Presentation
d)      Cache

2-      Which of them is/are not managed in Repository?
a)      Jobs
b)      Joins
c)       Catalog
d)      Variables

3-      Which of the Tools Utilities is not valid?
a)      LTS Column / Table Replacement
b)      Externalize String
c)       Updating Row Count
d)      Repository Documentation

4-      Which guided navigation type always appears on the Dashboard?
a)        Static links
b)        Static sections
c)        Conditional links
d)        Conditional sections

5-      Which of the Statement is/are incorrect:
a)      Repository Import to be activated from utilities
b)      Query Repository available in tools
c)       Projects to be allotted for MultiUser Development
d)      All are correct

6-   Which of the following is NOT true of the Business Model and Mapping layer?
a)      It determines what physical tables/columns can be used to satisfy queries
b)      It includes Connection Pool object and Schema folders
c)      It is where aggregation rules for measures are set
d)      It is where hierarchies are established

7-      This is/are a dimension where data changes rapidly
a)      Rapidly Changing Dimension
b)      Slowly Changing Dimension
c)      Junk Dimension
d)     Degenerate Dimension

8-      Dimension that is/are derived from fact table and does not have its own dimension table
a)      Rapidly Changing Dimension
b)      Slowly Changing Dimension
c)       Junk Dimension
d)      Degenerate Dimension

9 Which statements are TRUE of Filters? Choose two.
a) Filters are applied on a column-level basis.
b) Table level filters prompts can be added to a request.
c) Saved requests may be used as filters.
d) The SQL within a specific request cannot be edited.

10-   Request 1 returns Customers with Dollars between 5000 and 10000. Request 2 returns Customers with Dollars between 7000 and 20000. A union of these two requests should produce which of set of results?
a) Customers with Dollars between 5000 and 20000 plus duplication of Customers with Dollars
between 7000 and 10000
b) Customers with Dollars between 5000 and 20000
c) Customers with Dollars between 7000 and 20000
d) Customers with Dollars between 5000 and 7000

11-   Which of them is/are not Time Series Function?
a)      Ago()
b)      Todate()
c)       Period()
d)      PeriodRolling()

12-   What cannot be done in presentation layer of Repository?
a)      Nesting of folders
b)      Set implicit fact column
c)       Permission grant to groups/users for security
d)      Performing calculations of measures

13-   We can set Bridge table from
a)      Properties of Physical Tables
b)      Properties of Logical Table
c)       Properties of LTS
d)      Properties of Presentation Table

14. ABC would like to analyze which of its hundred stores have improved its order fulfillment rate last year. If ABC uses a dimensional modeling to answer the above question, which of the following would be its fact table?

a) Stores
b) Orders
c) Products
d) Time

15-   Which of the following is NOT true of a star schema?
a) The facts are quantifiable
b) The fact table has several foreign key columns composed of the primary keys of the related
dimensional tables
c) A fact table is linked to related dimension tables
d) Dimension tables are normalized
e) Dimension tables usually have a one-attribute primary key such as Product ID for Products

16-   Which of these is not Hierarchy type?
a)      Skipped Hierarchy
b)      Composite Hierarchy
c)       Parent Child Hierarchy
d)      Ragged Hierarchy

17-   Cache can be disabled from?
a)      Capacity Management Tab of Fusion MiddleWare
b)      Diagnostics Tab of Fusion MiddleWare
c)       Overview Tab of Fusion MiddleWare
d)      Deployment Tab of Fusion MiddleWare

18-   Repository can be uploaded/ updated from?
a)      Capacity Management Tab of Fusion MiddleWare
b)      Diagnostics Tab of Fusion MiddleWare
c)       Overview Tab of Fusion MiddleWare
d)      Deployment Tab of Fusion MiddleWare

19-   Log messages can be verified from?
a)      Capacity Management Tab of Fusion MiddleWare
b)      Diagnostics Tab of Fusion MiddleWare
c)       Overview Tab of Fusion MiddleWare
d)      Deployment Tab of Fusion MiddleWare

20-   You can start all BI services of fusion middleware from:
a)      Capacity Management Tab of Fusion MiddleWare
b)      Diagnostics Tab of Fusion MiddleWare
c)       Overview Tab of Fusion MiddleWare
d)      Deployment Tab of Fusion MiddleWare

21-   Calculations in logical columns are performed from which tab of logical tables?
a)      General Tab
b)      Column Source
c)       Aggregation Tab
d)      Levels Tab

22-   Which of the following stores content created by OBIEE Answers requests, filters, Siebel Intelligence Dashboards Pages, and the iBots?
a) Cascading Style Sheets
b) Repository file
c) Web catalog
d) Alerts

23-   In the current version of OBIEE (11g), java component used is:
a)      rcu
b)      oc4j
c)       Fusion Middleware
d)      Web logic server

24-   If you cannot view data of some physical table you should:
a)      Uncache the table
b)      Alias the table
c)       Update connection pool properties
d)      All of the above

25-   Which statement is true?
a)      If presentation column is renamed, logical column will get auto renamed
b)      If presentation column is renamed, physical column will get auto renamed
c)       If Logical column is renamed, presentation column will get auto renamed
d)      If Logical column is renamed, physical column will get auto renamed

26-      Other than Adhoc reporting & dashboards, what other features (for creating) are possible in recent version of obiee?
a)      Published Reporting
b)      Disconnected Analytics
c)       Actionable Intelligence
d)      Marketing

27-      Default Layout of adhoc report in results tab is?
a)      Title & Table View
b)      Table View
c)       Title & Pivot View
d)      Chart Pivoted view

28-      You can assign Administration & management rights to users / groups for answers/ dashboards or more products from?
a)      Manage Sessions
b)      Manage Interactive Dashboard
c)       Manage Privilege
d)      Manage Presentation catalog group or users




29-      Which Filter Operator is not valid type?
a)      Is blank
b)      Contains any
c)       Is in top
d)      Is in bottom

30-      Default Dashboard is set from?
a)      Administration
b)      My Account
c)       Dillivers
d)      BI Publisher

31-      How you can display two separate reports in same section to appear parallel.
a)      By Guided Navigation
b)      By Arranging Horizontally
c)       By Collapsible
d)      By Formatting Section

32-      Which of the following is not Dashboard object?
a)      BI Publisher Report
b)      Briefing Book Nav. Link
c)       Marketing
d)      Embedded Content

33-      Which is not valid type of set operation for combine with similar request?
a)      Union
b)      Intersect
c)       Minus
d)      SubSet

34-   Invalid Report View Type?
a)      Logical SQL
b)      Guided Result
c)       Create Segment
d)      Create Target List

35.   Localization (Language Preferance Setting) of dashboard is possible by?
a)      Administration
b)      My Account
c)       Login
d)      Dashboard

36-   How can you show updated changes made to online rpd, without restarting BI Services?
a)      Restart Java Host Services (Weblogic / oc4j)
b)      Reload EPT
c)       Reload Server Metadata
d)      Refresh Display

37-   How can you merge two separate reports from different subject area.
a)      Adding both reports in dashboard in same section.
b)      Clubbing two reports by OR logic
c)       By Combine with Similar Request Operation
d)      By Updating Request XML of Advanced Tab.

38-   If you successfully update any report in development environment, how you can generate same report with similar properties easily?
a)      By Pasting Request XML & SQL Issued from dev Advanced Tab to Prod / QA Advanced Tab.
b)      By creating report & updating all required functions/ filters from criteria tab.
c)       By Replacing prod / qa attribute files to dev atr files.
d)      Simply copying Request XML data from Dev & pasting to prod / qa.

39-   If you want to create any column (in criteria tab) based on certain calculation, you should:
a)      Use Filter option
b)      Use Function Option
c)       Use Column Format Option
d)      Use Sorting Option

40-   If you want to limit / restrict data based on some dimension attribute, you should:
a)      Use Filter option
b)      Use Function Option
c)       Use Column Format Option
d)      Use Sorting Option

41-   How can you update your date type dimension column to custom format (format of your choice).
a)      Use Filter option
b)      Use Function Option
c)       Use Column Properties Option
d)      Use Sorting Option

42-   How can you hide your criteria column?
a)      Use Filter option
b)      Use Function Option
c)       Use Column Properties Option
d)      Use Sorting Option

43-   How can you group by your column data:
a)      Use Filter option
b)      Use Function Option
c)       Use Column Properties Option
d)      Use Sorting Option

44.   Bins created in function are similar to:
a)      Case Statement of Expression Function
b)      Cast Statement of Conversion Function
c)       Count Statement of Aggregate Function
d)      RCount of Running Aggregate Function

45-   Which is not valid filter variable
a)      Session
b)      Repository
c)       Presentation
d)      Request




Tuesday, 13 January 2015

MCQ with Answers: OBIEE, Informatica, DAC, ODI, Dataware house concepts

Section A(Informatica)
1. A lookup transformation is used to look up data in
      A.flat file
      B. Relational table (wrong)
      C. view
      D. synonyms
      E. All of the above
  Answer: E

2. Which one support heterogeneous join?
      A. source qualifier
      B. joiner
      C. look up
  Answer: B

3. Which output file is not created during session running?
      A. Session log
      B. workflow log 
      C. Error log
      D. Bad files
      E. cache files
   Answer: E

4.Which is both connected and unconnected?
      A. External Store Procedure
      B. Store Procedure
      C. Lookup
      D. Advanced External Procedure Transformation
   Answer: A, B, C

5. Can we generate alpha-numeric value in sequence generator?
       A. yes
       B.no
      Answer: B

6. What is meaning of tracing level?
     A. Data store in cache (wrong)
    B. Data store in database
    C. Data store in log file
    D. Data store in buffer
    Answer: C

7.Which one contains input and output transformations? 
    A. maplet
    B. reusable transformation
    C. reusable mapping
    Answer: A

8. Which dimension is collection of random transactional codes, flags and/or text attributes?
    A. degenerated
    B. scd
    C. junk
    D. confirmed
    Answer: C

9. Which one is not a target Option for file on the Servers?
     A.FTP
    B. Loader
    C.MQ
    D.ERP
  Answer: D

10. Which one is not a designer tool creating transformations?
  
   A. Transformation developer
     B. Mapping designer
     C. Mapplet designer.
     D. target designer
    Answer: D

11. What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?
    A. Add one dummy port in two sources. 
    B. Use Joiner transformation to join the sources using dummy port 
    C. Use Union
    D. In expression trans assign '1' to each port
  Answer: A, B, D

12. What is the default source option for update strategy?
    A. Update or Delete
   B. Update or Insert
   C. Insert or Update
   D. Date Driven
  Answer: D

13. What is default join of joiner?
    A. Full Outer
    B. Detail Outer
    C. Normal
    D. Master Outer
    Answer: C

14.What is the default join of Source Qualifier?
     A. Left Outer join
     B. Equi Join
     C. Inner-equi join
     D. Outer join
     Answer: C

15. What are the types of groups in Router transformation?
     A. User defined group
    B. Multiple Group
    C. Default Group
   D. Single Group
Answer: A,C

16. Dimension tables are denormalized in nature ? True or False.
    A. true
    B. false
  Answer: A

17.How can we load time dimension?
     A. through Sql transformation
    B. through Dimensional Loader (wrong)
    C. Through Lookup
    D. Through Store Procedure
   Answer: D

18. Which are the load types in Informatica session?
    A. Bulk 
   B. Terse 
   C. Normal 
   D. All of these 
Answer: A, C

19. Which load type we should use in case of less amount of data and recover session?
    A. verbose
    B. normal
    C. bulk
    D. All of these
   Answer: B

20. Which one is not correct about filter transformation?
    A. Act as a 'where' condition
    B. Can't passes multiple conditions
    C. Act like 'Case' in pl/sql
    D. If one record does not match condition, the record is blocked
    Answer: B

21. What is a mapplet?
    A. Combination of reusable transformation.
    B. Combination of reusable mapping
    C. Set of transformations and it allows us to reuse
    D. None of these
    Answer: C

22. Which one is not an option in update strategy?
    A. dd_reject
     B.4
     C.2
     D. dd_delete
     Answer: B

23. Which transformation acts like CASE.. WHEN in Sql?
      A. filter
      B. router
      C. aggregator
     D. look up
    Answer: B

24. What will happen if informatica server doesn't find session parameter and variable?
      A. Work flow will fail
      B. Automatically it will created
      C. Give a message to user to put it
      D. none of these
      Answer: A

25. If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value, can joiner will match that null value?
      A. yes
      B.no
    Answer: B




Section B(DAC)

1. Can we run multiple execution plan at the same time in DAC?
     A. Yes. 
     B. No
    Answer: A

2. What are the components of DAC
    A. DAC Server
    B. DAC Client
   C. W ebLogic Server
   D. Informatica Server
  Answer: A,B

3. Can DAC send an email just in case of any failures?
   A. Yes
   B. No
   Answer: A

4. What kind of DAC Repository Objects Held in Source System Containers?
    A. Indexes
    B. Tasks
    C. Schemas
   D. Workflows
Answer: A, B

5. What is the default location where parameter files are created by DAC?
    A. $DAC_HOME\Informatica\server\parameters
    B. $DAC_HOME\Informatica\parameters
    C. $DAC_HOME\ parameters
    D. $DAC_HOME\ server\infa_shared\BWParam

Section C(OBIEE)
Methodology would you use?
          A. Type I Slowly Changing Dimension
         B. Type II Slowly Changing Dimension
         C. Type III Slowly Changing Dimension
         D. Type IV slowly Changing Dimension
Answer:B

2. When you open a sales.rpd file in the BI Server repository directory, it displays a message “The
repository sales.rpd can only be opened as Read-Only. Do you want to open it ?”. What is the
correct statement ?
        A. Oracle BI Presentation services is running
        B. Sales.rpd file can be opened only in the Online mode
        C. Oracle BI Server is running and Sales.rpd is the default repository
        D. None of the above
Answer: C

3. What do you use to Model a schema where the dimension table and the fact table have a many t
o many relationship ?
    A. Complex Join
    B. Aggregate Table
   C. Helper Table
   D. Split Table
   E. Bridge Table
   Answer: E

4. Which layer within the Oracle BI Repository provides customized, role based views to users who
build analyses and other client applications ?
   A. Physical Layer
   B. ETL Layer
   C. Business Model and Mapping Layer
   D. Presentation Layer
   Answer: D

5. What is the name of the object that is used to initialize dynamic repository variable and system
session variables for OBIEE Sessions ?
    A. Tokens
    B. Variables
    C. Initialization Blocks
    D. Meta Tags
   Answer: C

6. You can assign Administration & management rights to users / groups for answers/ dashboards or more products from?
    A. Manage Sessions
     B. Manage Interactive Dashboard
     C. Manage Privilege
     D. Manage Presentation catalog group or users
Answer: C

7. Which is not valid type of set operation for combine with similar request?
   A. Union
   B. Intersect
   C. Minus
   D. SubSet
   Answer: D

8. How can you show updated changes made to online rpd, without restarting BI Services?
    A. Restart Java Host Services (Weblogic / oc4j)
    B. Reload EPT
    C. Reload Server Metadata
    D. Refresh Display
  Answer: C

9. If you want to limit / restrict data based on some dimension attribute, you should:
     A. Use Filter option
     B. Use Function Option
     C. Use Column Format Option
    D. Use Sorting Option
   Answer: A

10. Bins created in function are similar to:
       A. Case Statement of Expression Function
       B. Cast Statement of Conversion Function
       C. Count Statement of Aggregate Function
       D. RCount of Running Aggregate Function
Answer:A



1. The full form of OLAP is
    A) 
Online Analytical Processing
    B) Online Advanced Processing
    C) Online Advanced Preparation
   D) Online Analytical Performance
   Answer: A

2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
     A) 
Data Mining
     B) 
Data Warehousing
     C) Document Mining
     D) Text Mining
    Answer: B

3. The data is stored, retrieved and updated in....................
     A) OLAP
     B) OLTP
     C) SMTP
     D) FTP
    Answer: B

4. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.
    A)  OLAP
   B) OLTP
   C) Both of the above
   D) None of the above
   Answer: A

5. Which of the following is not a kind of data warehouse application?
    A) Information processing
    B) Analytical processing
    C) Data mining
    D) Transaction processing
   Answer: D



Section E(ODI)

1. If you want to populate several targets, you need to insert several data stores in the target area?
    A. True
    B. False
  Answer: B

2. In ODI, references can be represented by
    A. Simple equalities between columns in tables
    B. Complex relationships between columns in tables
    C. Expressions that must evaluate to true or false
    D. All of the above
    Answer: A, B

3. You manually add and edit some elements of a model by using the ODI designer. After the model is saved in ODI, these changes update the underlying model in the database
    A. True
     B. False
     Answer: B

4. In a given context, how many physical resources can a logical resource be mapped to at the most
     A. None
     B. One
     C. Two
      D. Any Number
     Answer:  B

5. The following steps are preformed to set up an ODI repository environment:
      1. Create repository storage space
     2. Create the master repository
    3. Create one or more work repositories
      A. True
      B. False
     Answer: A