Re: [GENERAL] need help with Triggers

2010-11-08 Thread akp geek
I have listed functions, triggers , tables and view for your reference. Thanks for helping me out Regards CREATE OR REPLACE FUNCTION fnc_loadDenormdata() RETURNS trigger AS $BODY$ DECLARE v_transactionid numeric; v_startdate text; v_enddate text; v_statuscode character varying(10); v_

Re: [GENERAL] need help with Triggers

2010-11-08 Thread hubert depesz lubaczewski
On Mon, Nov 08, 2010 at 01:45:49PM -0500, akp geek wrote: > Hi All - > > Can you please share your thoughts and help me ? > > 1. I have 4 ( T1, T2 , T3, T4 ) tables where I have the data from > a transactional system > > 2. I have created one more table D1 to denor

[GENERAL] need help with Triggers

2010-11-08 Thread akp geek
Hi All - Can you please share your thoughts and help me ? 1. I have 4 ( T1, T2 , T3, T4 ) tables where I have the data from a transactional system 2. I have created one more table D1 to denormalize the data from the 4 tables ( T1, T2 , T3, T4 ) 3. I have