Question - What is the difference between transparent and non transparent database tables?
Answer -
Transparent tables have 1 - 1 cardinality b/w Data Dictionary and Database, and non transparent ( Cluster and Pooled) tables have Many - 1 cardinality.
Transparent table can access with using OPen & NAtive SQL stmts where as Nontransparent only OPen Sql.
Transparent trables can store Table relevent data and non transparent tables can store system data/ application data based on the transparent tables