Home Forums Data Warehousing Data Transformation Services (DTS) datawarehouse with DTS + stored procs only ? RE: datawarehouse with DTS + stored procs only ?

  • August 1, 2003 at 11:14 pm

    #468297

    quote:

    Our warehouse is currently 26+ Gigs and we load it with delta's daily in under 2 hours (along with the recon reports for balancing).

    Our datawarehouse is currently only ODS (ADS to be started soon) and 160+Gigs. Our daily loads (including reindexing and reporting) must stay under 12 hours. Can you give an idea on the size of your delta's ? (fi: 20% delta's a day)

    Thanks