In order to get more about your future client environment , you need to do a Datawarehousing Environment Assesment / questionnaire that sheds some light on it.
Oracle data warehousing environment , normally, would contain :
-Source database(s)
-Target database(s)
-ETL tool(s) , Extract – Transport/Transform, Load (Ex. Oracle Data Integrator ODI)
-Data warehousing Database
-Business Intelligence Tool(s)
-Reporting Tool
-Middleware Server Tool (ex. Oracle fusion Middleware)
While the client has more to tell, some important points can be missed .
The embedded excel sheet below table can help you to get an initial overview about that environment.
You may click it for editing purpose.
It is worthy to take care that the more questions got answered, the more you can estimate what the architecture is.
The Excel file can be downloaded from this link :
