Maintaining Reference Tables

View previous topic View next topic Go down

Maintaining Reference Tables

Post  ajviolette on Thu Oct 01, 2009 4:32 pm

I'm looking for some feedback regarding what tools others are using to maintain data in Data Warehouse specific reference tables.

These tables are typically used to provide cross reference or hierarchical definitions for the source data during ETL processing.

My previous company developed web pages for maintaining these special purpose tables that were stored in the staging area of the Data Warehouse.

My current company has been using Excel spreadsheets to store and maintain these tables, but we want to get away from this practice.

Informatica in it's latest version of PowerCenter has this functionality, called Reference Table Manager, but this first version seems limited in terms of user friendliness (doesn't appear to have capability for pull down lists of values for data entry.)

Information on other approaches would be appreciated.

ajviolette

Posts : 1
Join date : 2009-10-01
Location : Minneapolis, MN

View user profile

Back to top Go down

Re: Maintaining Reference Tables

Post  ngalemmo on Thu Oct 01, 2009 4:41 pm

I've used Access in the past. You can link directly to the database tables and throw together simple applications very quickly. It's not 'industrial strength', but certainly serviceable for this type of application.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum