|
Archives of the TeradataForumMessage Posted: Fri, 10 Sep 2004 @ 18:16:32 GMT
We are looking to use PS. We are facing a fundamental question : Should I define the partitions along the type of work (tactical, strategic, ad hoc etc), lets call this config A, or should they be aligned by the business units (supply chain, HR, sales etc) config B? Carrie's orange book shows 3 templates with template 1 and 3 corresponding to the above 2 alternatives respectively. I would like hear pros and cons from users on the alternatives. Here is a start. Config A - by type of work Pros * Supports to enterprise vision and the typical DW classification of work * The number of types of work is very stable Cons * ?? Config B - by business units Pros * (assuming business units are charged back), reserves database resources to a business unit based on what they paid for Cons * The limit of 5 RPs poses restrictions on scalability of business units Is it possible to get the best of both worlds by defining the RPs by business units and the 2nd level Performance groups by type of work? I understand how we use PS depends on specific issues we are trying to address at our site. For now, lets keep it neutral and assume the discussion is for a typical Teradata installation that's growing steadily. Kumaran Anantaraman
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||