We have a on Premises Data Warehouse with multiple transnational source system (Mainly EBS) , Informatica Powercenter as an ETL tool with an on Premises Oracle Database and OBIEE as Dashbording tool. Our current challenge with this setup is constant tuning of the ETL processes and SQLs geenrate by OBIEE. We need to keep developing new long running ETL processes to build Agggregate tables based on other DW tables to improve performance. We just started using Azure for some of other initiatives but would like to see if and how we can use Azure to help with our existing DW challanges. can someone help with a highlevel plan of how we can leverage our Azure investment to gradually migrate current DW data that can adress our challanges?
Thank you!
