Re: Data Warehouse Population

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

Ok, Broad response to Broad question.

Yup.

Now, IMNSHO...

Get the DASD. Journal the operational store. If your company is warehousing
it, it must be worth it to them to keep it consistent and protected.

Next, again IMNSHO, look into Data Propagator Relational. Why? There is no
"real" overhead on the operational store other than the journaling.

Instead of full loads, changes to the data can be scheduled to be sent to
the target systems throughout the day or in bulk and the only real limit to
data-massage during the transfers is what you can't accomplish with 32,767
SQL statements per table, you might just have to write a program for.

Again, you just send changes. NO application changes at all. No trigger
changes to the files. If you have triggers on now, you don't have to figure
out a way of adding more triggers. If you want to add triggers for some
other purpose, you don't have to re-visit the propagation code.

Everybody wins...

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"

-----Original Message-----
From: Mark Bennett <mbennett@clover.co.za>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Friday, January 07, 2000 4:45 AM
Subject: Data Warehouse Population


>
>
>I would appreciate any comments on this 'broad' question.
>
>The environment consists of several remote AS400's populating a central
Data
>Warehouse.
>
>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.
>
>Thanks
>Mark
>
>
>
>+---
>| 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
>+---
>

+---
| 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
+---