Hey Guys,
I had a quick question?
Informatica will be used as the ETL tool to facilitate incremental data extract from Veeva(CANADA AND US DATA) into the Staging database. Oracle will serve as the Staging database to which SAP BI will connect to extract the Veeva data on a daily basis.
Initially we used excel files to extract data.
Oracle views are created on top of the data tables in both the Staging schemas which will be referred by SAP BI to extract data into their system to be used for reporting.
I need some quick comments on this.
What changes need to be incorporated to use Oracle now as the main source to extract data? Will i face any problems???
Thanks for the help!!!!!