This is a grid mentioned in our video titled Physical VS Virtual. The grid provides the pros/cons between persisting data into a physical form vs.pros/cons of using virtual tables.

Physical vs Virtual DW

 

Virtual

Physical

Pros

Cons

Pros

Cons

Real Time Capable Chaotic to Maintain Easy to Audit Difficult to Change
Buffers Anomolies Difficult to Scale Sources Fast Queries Latent Data
Easy to Prototype Difficult to Trace History Tracks History Sensitive to Volitility
  Late Arriving Data Issues Whole Transactions  
  Excessive Query Compute    

 

 

TO CONTINUE READING
Register Here

appears invalid. We can send you a quick validation email to confirm it's yours