From operational data store to warehouse

Question

I have 3 ODS, so in order to create DWH, do I need a DWH for each ODSs, or the DWH select the tables from any of the ODSs?

Can you please share details of each of your ODS ? – Amira Bedhiafi Aug 15 '21 at 21:24 — Amira Bedhiafi, Aug 15 '21 at 21:24

NickW · Answer 1 · 2021-08-08T11:47:11.327

1

The design of a DWH is based on your reporting requirements. The number and locations of any data sources is entirely irrelevant.

Also, please can you explain what you mean by the phrase "the DWH select Dim table for any of the ODSs"? It doesn't make much sense to me

edited Aug 08 '21 at 11:47

answered Aug 08 '21 at 11:40

NickW

I meant to say: he DWH select the tables from any of the ODSs? – Ahmed Algosaibi Aug 08 '21 at 12:11

1 Answers1