Hi, there,
I got some problems on oracle designer editor and I am wondering if anyone can help me out.
We are asked to edit the first cut tables, which are mapped automatically by the Transformer. We are also required to compare the difference between the first cut tables and those have been modified by the Editor. Actually, I am satisfied with the table definition reports generated on the first cut tables as they provide more information on the foreign keys but there are lots of duplicated paragraphs and pages on these reports and I just could not get rid of them. For those have been modified by the Editor, I am not satisfied with the reports as some information is lost after we deleted some columns. I am not sure which column I should delete, should I delete those attributes existed in the entity relationship diagram or the columns which come as a result of foreign key relationship? For e.g., in a Customer Table, there are columns as follows:
1 #customer_ID
2 *customer_name
3 *subsidy_category
4 *subsidy_class
5 sub_category
6 sub_class
column 5 and 6 come as the result of a foreign key relationship between the Customer table and Subsidy table. In subsidy table, subsidy_category and subsidy_class are pks. It seems 3&4 are repeated by 5&6. Should I delete one of them or keep both of them in the table but hide one of them? Does anyone know how to get rid of the duplicated paragraphs and pages in the reports?
Kelly