datahub icon indicating copy to clipboard operation
datahub copied to clipboard

DDW Fact

Open Napho opened this issue 7 years ago • 6 comments

Move data from mirror databases to fact tables. Fact table holds aggregated data values from which other schemas that directly relate to ddw UI get pick their data values

Napho avatar Jul 17 '18 07:07 Napho

Non-dac deflators needed to generate the final master deflator table for use in the ddh update. Deflators are from DAC1, DAC2A, DAC2b and DAC5 mirrors, if the deflator cannot be found, in any of the above then IMF deflators should be used, if IMF cannot be used then World Bank has to be used

Napho avatar Aug 07 '18 11:08 Napho

@Napho @Duncan-Knox can you add more detail here following your meeting?

k8hughes avatar Aug 09 '18 10:08 k8hughes

We are looking into the deflator requirements for the fact data series.

Duncan-Knox avatar Aug 09 '18 11:08 Duncan-Knox

It seems that there are some things that don't need deflating, should we split this and have a separate ticket for the population stuff so that part can be completed and passed to the front end?

k8hughes avatar Aug 09 '18 14:08 k8hughes

@k8hughes that is the plan now, we are trying to single out tables that don't need any deflation to be worked on first in this sprint, then save the heavier work for the later part of the sprint

Napho avatar Aug 09 '18 14:08 Napho

Is this issue now able to be closed?

k8hughes avatar Dec 17 '18 08:12 k8hughes