page254
341
Apply a single filter to
base_customer_order.order_key
, setting the value to
********
:
INSERT INTO client_mask
SELECT seq_client_mask_id.NEXTVAL,
( SELECT client_id FROM client WHERE name = 'POC' ),
'[ORDER_KEY_MASK]',
'order_key',
'''********''';
Denormalize Client Information
With all your client entities both created and populated, you should denormalize the
client-specific components to make your data model more easily understood and user
friendly. You do this by creating a view called
v_client_info
to join all client-specific
tables together.
CREATE OR REPLACE VIEW v_client_info
AS
SELECT c.name AS client_name,
c.account AS client_account,
co.object_name,
cf.filter_name,
cf.filter_attribute,
cf.filter_value,
cm.mask_name,
cm.mask_attribute,
cm.mask_value
FROM client c,
client_object co,
client_filter cf,
client_mask cm
WHERE c.client_id = co.client_id
AND c.client_id = cf.client_id
AND c.client_id = cm.client_id;
Chapter 9
Client expeCtations