Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Design fact updates

  1. #1
    Join Date
    Jul 2012
    Posts
    200

    Default Design fact updates

    Hi

    How to handle scd type2 updates in the fact table ? I am not doing incremental loading on the fact table. Any good approach to follow. Can anyone suggest me good solution when i am loading the data into the fact table. IF we have millions of rows how to do this without hitting the performance.

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    It's not clear what you're trying to do. Are you trying to use slowly-changing dimensions, such as when a customer changes from single to married? Or are you trying to use slowly-changing facts, such as a process that occurs over time? Or something else?

    I don't understand what you mean by "scd type2 updates in the fact table" if you are "not doing incremental loading on the fact table." That seems to be a contradiction.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.