Denormalization with designer 6i
Date: Thu, 13 Dec 2001 21:57:18 -0800
Message-ID: <zXdS7.15115$Us5.3382398_at_news20.bellglobal.com>
Hi,
My environment is designer 6i on oracle 8i.
I have the table B where I denormalize the column C from the table A.
In designer, I specified the denormalization and the server derived properties of the column C of the table B.
If I insert a new row in the table B, The column C of the table B is set automatically from the corresponding column in table A. It's done with the TAPI. If I update the column C of the table A, the column C of the table B is not set.
So, the denormalization is not fully implemented with Designer. The TAPI of the table A (for the update) is supposed to have the denormalization rule, but this rule is not there.
Is it a Designer bug or I have to program the rule for the update on table A ?
Do you know a good book (user's guide) for designer 6i ?
Thanks a lot. Received on Fri Dec 14 2001 - 06:57:18 CET