Interview Questions   Tutorials   Discussions   Programs   Videos   

OBIEE - What are opaque views in database? When is it advisable to create one?




1672
views
asked kumar5430 May 21, 2014 04:34 AM  

What are opaque views in database? When is it advisable to create one?


           

2 Answers



 
answered By   0  

A Sql query/ select statement is called as opaque view.In worst scena
rios we go for opaque view.

after creation of opaque view in rpd if we not deployed into database,if we use opaque in reports then oracle bi server need to create complex queries.To avoid these complex queries we required to deploy opaque view in to database.
flag   
   add comment

 
answered By SRVMTrainings   0  
The opaque views are tables that are created with join or other query data that contain ?SELECT? query output. The opaque views make the logical understanding simple for implementation but there are heavy performance constraints. They are only used when there is no other way to get to the final solution.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  Question tags

obiee × 1

Asked 5 years and 11 months ago ago
Number of Views -1672
Number of Answers -2
Last updated
3 years and 6 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert