Friday, January 8, 2016

Explain the difference between pool tables and transparent tables?

Transparent tables:  It has one to one relation with the table in the database.  Its structure corresponds to single database field.

Pooled tables: It has many to one relation with the table in the database.  Pooled tables are stored at the database level.

a)      Basic List: For simple reports

b)      Statistics:  For Percentage, Average etc.

c)       Ranked List : For analytical reports

No comments:

Post a Comment