By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
To maintain a single data warehouse/mart implementation our development team needs to access 50 user ID/password/server combinations. The architecture is one where atomic-level detailed information from fuel cost and billing systems is brought into the DW dimensional models then aggregates dimensionally modeled are generated in the data mart. The account access information is too much for anyone to remember so it is out on the server in a text file for reference and our passwords are not secure/changed because synchronizing them and parameter files is a task and a half. Basically our DBAs have gone wild architecting the environment without project/ETL team input. What is an ETL/project team to do in such an environment? Is this the norm?
Dig Deeper on Oracle data warehousing
ETL tools provide very robust support for complex business logic.continue reading
A SearchOracle.com member asks why a low-cost query has a slower speed than expected.continue reading
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.