Data Management & Warehousing - Specialist Consultants in helping you and your Data Warehousing projects
 
 Data Management & Warehousing
 
 • Home • Knowledge Base • Hints & Tips • About Us • Contact Us • Bookmark Us • 
Log In
Username

Password

Remember Me


Main Menu

Quotes
"Make everything as simple as possible, but not simpler." --Albert Einstein

Data Warehousing Links

Science & Technolgy News

PC Security

Data Warehousing

Data Warehousing

Data Warehousing information		 Data Warehousing
Parent:Technology
Article Manager
Detecting Changed Data
Last updated by RonBallard on 12/18/2009 11:55 AM (Read: 9944 times)
Data Warehousing

Description of a method to identify changes from one version of an extract file to the next.

[Read More] 1088 more words - 1 page 9 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Basic Data Quality Audit
Last updated by datamgmt on 09/22/2003 02:11 PM (Read: 7819 times)
Data Warehousing

This article looks at basic data quality audit that can be done within a database. Examples are given using Oracle syntax however the techniques can also be applied to other databases

[Read More] 318 more words - 1 page 2 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Bitwise calculations and Message Digests in Oracle
Last updated by datamgmt on 06/26/2004 06:32 PM (Read: 10366 times)
Oracle Data Warehousing

It is often useful to have bitwise and message digest algorithms for use in a data warehouse. But where can we get some from ?

[Read More] 81 more words - 1 page 3 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Building Data Marts
Last updated by datamgmt on 07/11/2004 08:48 AM (Read: 12320 times)
Data Warehousing

This article descibes building data marts from a data warehouse or transaction repository. It discusses the merits of full and incremental loads for different data marts.

[Read More] 863 more words - 1 page 7 Comments Printable VersionPrint E-mail this Article to a FriendeMail

CSV File Format
Last updated by datamgmt on 12/10/2009 02:52 PM (Read: 9473 times)
Data Warehousing

We all know that we should be writing file extracts as XML but if we really need to get a CSV file then here is how to do it

[Read More] 607 more words - 1 page 9 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Job scheduling - fixed and relative timing
Last updated by datamgmt on 07/11/2004 07:55 PM (Read: 10710 times)
Data Warehousing

This article looks at the relatve merits of two types of processing schedule, once based on a fixed times (similar to 'cron' on a unix system) and onebased on relative times (similar to 'at' on a unix system)

[Read More] 753 more words - 1 page 3 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Keysum - Using a checksum for a primary key
Last updated by datamgmt on 07/17/2003 09:58 AM (Read: 10643 times)
Data Warehousing

Description of a method to use checksums as keys

[Read More] 810 more words - 1 page 4 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Key Design Decisions
Last updated by datamgmt on 07/17/2003 09:38 AM (Read: 6551 times)
Data Warehousing

KDD template for recording data warehouse design changes

[Read More] 40 more words - 1 page 3 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Data Transformation - Procedural and Non-Procedural Solutions
Last updated by datamgmt on 07/11/2004 07:39 PM (Read: 13550 times)
Data Warehousing

This paper looks at a somewhat awkward data transformation, and at solutions written in SQL and in a procedural language. It describes some techniques which can be used to develop the solution in both languages. It also compares the solutions in terms of ease of development, performance and cost of maintenance.

[Read More] 4860 more words - 1 page 7 Comments Printable VersionPrint E-mail this Article to a FriendeMail

Auditing Data Cleaning Updates
Last updated by datamgmt on 07/17/2003 10:01 AM (Read: 5870 times)
Data Warehousing

How to track what has been updated by data cleaning processes

[Read More] 276 more words - 1 page 1 Comment Printable VersionPrint E-mail this Article to a FriendeMail

<<  [ 1 ]  >>
1 - 10 of 10

ETIS
We are an associate member of
ETIS

Are you linked in ?
See David Walker's
View David Walker's profile on LinkedIn
Profile

Twitter

Use Skype To Contact Us
Skype Me!

RSS Feeds

googlesvcs from Data Management & Warehousing, the Data Warehousing knowledgebase and consultancy

WWW   Site

Who's Online
There are currently
7 guest(s) and
0 member(s) online.
You are an
Anonymous user.
You can register for
free by clicking here

No Members are currently logged in.

Your IP address :
38.107.191.82

Your country is :
Unknown
Unknown

Legal

Valid RSS!
The content of this site is Copyright (©) 1995-2007 Data Management & Warehousing Ltd
 Valid XHTML 1.0! Valid CSS!
Registered Office: 138, Finchampstead Road, Wokingham, Berkshire, RG41 2NU, United Kingdom
Registered in England and Wales; Registration Number: 3526504; VAT Registration Number: GB 724 4482 36
This site is powered by phpWebSite © The Web Technology Group, Appalachian State University and licensed under the GNU LGPL