What is a derived table in data warehousing?

Answer Posted / karthik1981

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are linked universes? : bo designer

506


How to do scheduling in desktop intelligence in bo xi r2? : sap bobi

457


We have a lot of tools available under business objects platform. Will a company have to purchase the entire suite or does the SAP provides a way for organizations to buy only the tools which are needed?

473


What is a client tool? / Why webi is referred as a client tool?

508


How can Contexts be created?

525






What is an online and offline mode? : sap bobi

523


Explain how can custom hierarchies be created?

534


What is repository? List the types of repositories.

488


What are business objects?

500


What is a cartesian product? : bo designer

512


What is the use of compact repository?

932


What are the different kinds of data providers?

469


How many approaches are there for linking universes? : sap bobi

428


In my universe, I deleted Year object again i re-create the New Object named as "Year" in the same universe. How the document will be generate before deleted and after deleted in web intelligence rich client?

1172


What is difference between normal crystal reports and sap crystal reports. Why sap acquired the crystal report.

1430