What is the difference between transparent and non transparent database tables

  • Interview Candidate
  • 1
  • 1943

Showing Answers 1 - 1 of 1 Answers

Vishnu

  • Jun 26th, 2006
 

Transparent tables have 1 - 1 cardinality b/w Data Dictionary and Database, and non transparent ( Cluster& 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions