Re: Data Warehouse Population

Mark,

In a message dated 1/7/00 4:30:41 AM Eastern Standard Time, 
mbennett@clover.co.za writes:

<<snip>>
> Can I use triggers and DDMF's to populate this Warehouse. Is this a 
practicle
>  alternative to FTP'ing large files periodically. The intention is to 
'spread the
>  load'. The codeing in the trigger pgms would obviously have an impact on 
the
>  performance.

Certainly sounds better than the wholesale transfer of large chunks of data 
on a regular basis.  I guess the question is, why not just update the DDM 
files directly from the remote locations?

Regards,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-mail:  DAsmussen@aol.com

"The greatest joy in life is doing what others say you cannot do." -- Walter 
Bagehot
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---