What is a derived table in data warehousing?
Answers were Sorted based on User's Feedback
Using SQL queries in the database level, Derived tables are created in the universe.
The column of the derived tables will be the column selected in the query. Derived tables
Is used to complex calculations which are difficult to be achieved in the report levels. Using DB link,
Tables can be accessed from a different schema, is another use of different schema.
Is This Answer Correct ? | 0 Yes | 0 No |
Derived tables are like Views in the Database level.It uses the complex calculations from different tables and maintained in a single table.But it will affect the performance.
Is This Answer Correct ? | 0 Yes | 0 No |
What is a client tool? / Why the web is referred to as a client tool? : sap bobi
List out the different products related to Business Objects?
Can you please clarify the difference between compatible and incompatible objects?
What are the steps included in data integration process?
Explain designer?
Define strategies? : sap bobi
Can you create Alerts in WEB Intelligence?
Explain how can contexts be created?
A project requires the parsing of names into given and family, validating address information, and finding duplicates across several systems. Name the transforms needed and the task they will perform?
What is external strategy? : bo designer
What are object security access levels? : bo designer
Define the universe? : sap bobi