Post reply

ETL procedure for a Table with sparse columns

  • June 8, 2016 at 9:08 am

    #327435

    Hi,

    I have got requirement to create store procedure for ETL process, ideally using merge and Matched statement, but the table got sparse columns and column set, could any give some idea how to get on it. we have data in XML format and sql table. I need to create two store procedure for this.

    Many Thanks in Advance

  • June 8, 2016 at 9:18 am

    #1883899

    There's no difference ETL wise.

    having SPARSE columns lets SQL optimize for mostly null values, and that's under the hood, albeit potentially a bit slower.

    I think of sparse columns the same way i do indexes when it comes to ETL:

    indexes exist, but don't directly affect an ETL; indirectly, there might be some data juggling, but nothing you have to code for.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply