why we are using derived tables ?how it will help?

Answer Posted / sampath kumar

Instead of Aggregated table we use the Derived table.
Aggregated table will be created by ETL people, for
summarized columns we use Aggregated table.

Is This Answer Correct ?    0 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the profile and package?

2082


Can anybody tell me what are the tuning problems?

1807


what are the day to day activities of BO administrator ?

2540


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

843


What is the difference in creating filters in designer and business objects?

813


What three things do you consider to be the most important factors for a manager?

836


Give some information on report bursting?

783


Explain what sort of existing documents should business analysts refer to when starting on a new project?

792


What is a fantrap in business objects?

837


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1946


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10350


What are the steps to do to use alerts in bo?

865


What is top business?

760


What is the difference between business requirement document and use case document.

788


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2011