.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

To shred or not to shred

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
 
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


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend