Differentiate between transparent and pool tables.

Answer»

Transparent Table	Pool Table
It has ONE to one relation with the database table	It has many to one relationship with the database table
It contains only a SINGLE table	It contains a LARGE number of small tables
Stores master data	Stores customizing data or system data
A SECONDARY index can be created	A secondary index cannot be created
Can be accessed using Open and NATIVE SQL	Can be accessed only using Open SQL
The database table will have the same name, the same number of fields, and the same field names	The database table will have a different name, different number of fields, and different field names

Discussion