Dealing with a terrible OLTP system. Long, but I'd appreciate some expert guidance. 
DavidStein at 15h29
23
Aug
2010
Dealing with a terrible OLTP system. Long, but I'd appreciate some expert guidance.
To recap, I am dealing with an OLTP with the following characteristics.
It doesn't have any Primary or Foreign Keys and lacks referential integrity. It does have clustered unique indexes created on identity columns in most tables.
A majority of the fields are CHAR fields, even those that should rightly be integer or other field types. It does however, correctly use Datetime fields.
To recap, I am dealing with an OLTP with the following characteristics.
It doesn't have any Primary or Foreign Keys and lacks referential integrity. It does have clustered unique indexes created on identity columns in most tables.
A majority of the fields are CHAR fields, even those that should rightly be integer or other field types. It does however, correctly use Datetime fields.
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1842
- Numbers of messages : 8656
- Numbers of users : 3787
- Numbers of points : 1497
Similar topics
I'm very new to the Data Warehousing arena from an OLTP background and have just had the sudden realization (as I'm sure many do) that it's not simply a case of OLTP with dimensions and surrogate keys
My problem is such:
1. We have a system that has
I have a set of reports that are going against OLTP systems since the requirement is for real time data reporting. There is a request to improve performance.
Could you suggest ways to do so, data warehouse is not an option. Is ODS better? what are the
Can we build cubes on top of OLTP systems
What is the best field to use as Effective From Date in DW ? Audit field from OLTP or the System time when inserting into DW.
If we use second option we have following two issues...
1. we are not accurately recording the time the record created in ou
hi all,
I need to ask the experts in this forum about how to be an expert in Juniper like my skills related to Cisco ???
I have some of Juniper Certifications:
JNCIA-ER
JNCIA-EX
JNCIS-ER
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
Search
See also
Informations
4 Replies For the topic :
"Dealing with a terrible OLTP system. Long, but I'd appreciate some expert guidance. "
This topic has been viewed 1439 times.
Last message :
23/08/2010 at 15h29 by "DavidStein"
