I'm working with a new client on a Business Intelligence (BI) application where the source data is JSON. I figured I would use an off the shelf conversion tool to go JSON to XML and store the XML in SQL Server 2008. For a BI application is
it best practice to (1) Query Directly from XML or (2) Shred the XML and persist the relational data into tables which are then fed into the BI application?
View Complete Post