DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3564
Location: Australia, Melbourne
Points: 27712

Post Posted: Thu Sep 29, 2005 6:30 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
roy

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 30 Jul 2003
Posts: 2598
Location: Israel
Points: 21548

Post Posted: Fri Sep 30, 2005 1:00 pm Reply with quote    Back to top    

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,

_________________
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours