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
A SearchOracle.com member asks why a low-cost query has a slower speed than expected.
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 ...
I am new to Oracle's ETL tool and I need information on data migration using Oracle ETL.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.