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
7454 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 static filter and dynamic filter

1 Answers

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

4 Answers

what is diff between Decode and case ? Give some Example?

2 Answers

Can we create universe with no cache??

0 Answers

Explain is data mart?

0 Answers

When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??

2 Answers Rolta, TCS,

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers Wipro,

What is the use of BO SDK?

5 Answers

Why do we need metrics and sets?

1 Answers

how to overcome overflow of data in a report

6 Answers

What are Alerter, Filters, Breaks and Conditions?

2 Answers

@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers iGate,

For more Business Objects Interview Questions Click Here