To have staging tables? RRS feed

  • Question

  • Hi,

    I have a customer who is supply me 10 tables - some have reference data and some have customer data.

    The tables are strongly typed.

    They want me to load, cleanse and match records and load the data into a set of tables used by an application I developed for them.

    Should I just do this(cleanse and match) on the fly using their tables or should I have a set of separate staging tables in my database where I load their data first?

    My staging tables will essentially be a copuy of theirs and will have same types?

    Any advice appreciated.



    Thursday, October 16, 2014 11:27 PM


All replies