The aim of this project was to develop Data mapping within an asset allocation analysis Portal, the system receive accounts payable raw data (text files) from the client from different systems (ORACLE, ,SQL SERVER) which will be converted into SQL Data. Firstly, we needed to understand how the data look like as per the accounts payable . we needed to check , if we got correct tables and all the necessary tables which are used for accounts payable. Also, we needed to check for the credits, debits, payment and journals. Here joins were created between the client tables and after running certain scripts finally transaction table will be created
Senior BI Berater mit Schwerpunkt in Data & Cloud Themen rund um Datenmangement und Datawarehousing speziell im Bereich Azure.
Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.