Data denormalisation seems some attractive

2003-09-30 Thread Stephane Paquette
Hi, A co-worker of mine is working on a tiny project. Let say you have commission info and commission details, there are 7 types of commissions. The 7 types of commission shares common fields (from 100% to 30%) From a conceptual point of view, you have 1 entity that is the commission info and 7

Re: Data denormalisation seems some attractive

2003-09-30 Thread Jared . Still
Paquette [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data denormalisation seems some attractive Hi, A co-worker of mine is working on a tiny project. Let

RE: Data denormalisation seems some attractive

2003-09-30 Thread Stephane Paquette
Hi Jared, Here are more details. One commission detail must be one of the types: manager override (12 fields) first year commission (15 fields), renewal service fee (10 fields), charge back (9 fields), vesting payment (1 field), subsidy (2 fields), supplementary commission

RE: Data denormalisation seems some attractive

2003-09-30 Thread Jared . Still
recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data denormalisation seems some attractive Hi Jared, Here are more details. One commission detail must be one of the types: manager override (12 fields) first year commission (15 fields), renewal service fee (10