Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Questions about sample demo for type2 SCD

  1. #1

    Default Questions about sample demo for type2 SCD

    Hi,
    I found a demo for type2 SCD in sample / jobs directory .when I run this transformation ,I should get 4 simpel output row but I actually get five .There is customer_tk =00000001 and version = 0000001 row in output I just want to know where is this row come from?

    Thanks
    Alex

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It's the "unknown" row found in every slowly changing dimension.
    If you don't have it, you can't guarantee referential integrity between facts and dimensions.

    Matt

  3. #3

    Default

    I didn't realize that util you remind me, I was thought it's related with get system info step.It's a very good implementation,but I think it's better to docuement it on the 'User's guide'.

    Thanks
    Alex

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.