Is Cache the preferred database source for extracting data elements for use in Health Share Patient Index or is there a significant benefit in sourcing data from a warehouse, data mart, or MV? I realize that could be a loaded question with 100 other questions that may follow, however, if there is a known advantage to extracting data from a particular data storage type, the answer may highlight that point.
Our team is in the inception and elaboration phase of using the Health Share Patient Index solution. Our road map has checkpoints to integrate data storage within a Cache DB as well as into a warehouse and/or data mart(s). Essentially, what I want to know is there a significant advantage to sourcing data from Cache vs a warehouse or data mart so that we may elaborate the idea further and plan accordingly.