What is a derived table in data warehousing?

Answer Posted / padmaja.m

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps included in data integration process?

472


What is the purpose of @functions?

514


Explain the concepts and capabilities of business objects? : sap bobi

422


With what extension the universes get created in idt? : sap bobi

477


What types of join paths return incorrect results? : bo designer

497






What are the kinds of modes associated with designer and business objects?

542


List out the tasks of universe designer? : sap bobi

435


Can you define slice in business objects?

464


What are the differences between personal, shared, and secured connections? : sap bobi

442


How do you distribute a universe? : bo designer

467


Define Slice in Business Objects?

519


What are the diverse kinds of information suppliers? : sap bobi

460


Can you explain context in the universe?

489


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

1430


Explain the arrangement of sap business customer apparatuses? : sap bobi

482