DSXchange

Are you using materialised views? What do you like about them?

Our project is considering using DB2 materialised views for reports instead of queries against tables. One particular features looks very useful, the ability to freeze the view to a snapshot even when the underlying tables are being updated, and then refreshing the view with a command when the loads are complete. Might also be good for rollback of failed ETL jobs.

Hi Vincent,
I don't see any real benefit regarding the rollback if etl job failed since it's not different then using a staging area and switching between tables/partitions.

Many a time the configuration best suted for loading your target DB is not the best one to extract reports from and if this doesn't support having source and target being partitioned differently or having diffrent indexes then you might have a problem tuning for better performance.

IHTH,