Skip to Content
0
Former Member
Jul 02, 2015 at 06:34 PM

When and what situation we prefer derived table

412 Views

Hi All,

I have a doubt. I know Derived table is like view in universe (universe design tool or information design tool) and we create it by using SELECT statement.

But when we prefer Derived table instead of normal tables or aggregate tables.

Can any one plz explain this. If possible explain any situation where we prefer derived tables instead normal .

Thanks,

Poorna