Re: Incremental update for files

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Are you journaling your production files? If so, you could use your
journals to add or update your data warehouse files.

Regards,

Luis

Sent from my Moto G phone. Please excuse my brevity.
On Jun 12, 2015 3:04 PM, <darren@xxxxxxxxx> wrote:

> We're planning to do a daily snapshot of a bunch of production data
> (millions of records) for a data warehouse/reporting tool called Cognos.
> The refresh takes quite a bit of time, and a lot of it is historical.  So,
> are there any options for net changing or incremental refreshing these
> files?  We're avoiding using production files directly for a number of
> reasons.  One of them is that we're also building quite a few summary
> tables, and the detail needs to match up with the summary data, which it
> would not, if transactions are happening during the day.
>
>
>
> ___________________________________
> Darren Strong
> Programmer/Analyst
> Group Dekko, Inc.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.