I have requirement to design a data model out of flat files, there are 40 different sources I will be getting flat files. Now I have a revenue and quantity key figures from flat file will have different currencies and various unit of measures.
My company does reporting in USD and Kg's.
My question is do I need to request in flat file both local and USD values for revenue? or can I do currency translation to a USD in my BI system ; if so what are other parameters I need to request from Flat file source like exchange rates..etc ?
Since I am dealing with more than 40 different sources, currency translation at my end is a viable option ? please explain the pro's and con's of the scenario. Which is way is more flexible. Similarly with Unit conversion