HomeData warehouseMethods for populating a data warehouse

Comments

Methods for populating a data warehouse — 4 Comments

  1. Pingback:Link Resource # 18 : Aug 19 – Aug 22 « Dactylonomy of Web Resource

  2. I have a fact table which has about 27 million records and i am trying to update the fact table so i don’t have to fully process the cube every day. The pattern i am following is using look ups to verify whether it an existing record or a new record. I am using SSIS as the etl tool. I am wondering what would be the best way to handle it. Should i load the Source system key from the fact in a cache look up and then compare or try to follow something else.

    Any response or help would be really appreciated.

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>