IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

Question Posted / riazahmedshaik

1 Answers
7355 Views
Accenture, I also Faced
E-Mail Answers

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?..

Answer / sahil

Although view is faster than derived table, but if we want
to filter out the data from select query of derived table
then we can use @prompt in derived table. but it cant be
done in views.

Is This Answer Correct ?

11 Yes

5 No

Post New Answer

More Business Objects Interview Questions

What is the degenerated Objects?

2 Answers

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

2 Answers Accenture,

can anybody tell me how many classes where there and objects in each class

3 Answers

What we need to discuss with designer before starting the universe designing.

0 Answers BMC,

Hi any done business objects certification.i am expecting some help from them.

6 Answers

Explain the difference between compatible and incompatible objects?

0 Answers

What is the strategies ? what is the need of the strategies?

2 Answers IBM,

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers Cap Gemini, Infinity, TCS,

What is the sheduling the report? What is the need of sheduling the report?

1 Answers Wipro,

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers BirlaSoft,

Can Bo generates the Report from the cubical data Explain?

0 Answers Wipro,

how do u implement dense rank in a report?

1 Answers CTS,

For more Business Objects Interview Questions Click Here