Skip to Content
avatar image
Former Member

EFFECTIVE_DATE TRANSFORM

Hi,

Can anyone explain me what is effective_date transform with an example? and when it is useful in the scenarios?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 29, 2014 at 08:32 AM

    Hi Santosh,

    Effective_Date Transform:

    1. • Generates an additional Effective_To_Column based on the primary key’s “effective

    date”

    • For this the Data Input should have an effective date column.

    • Effective_Date allow you to indicate changes to information over time. This Can be used to

    implement SCD Type 3

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi Santosh,

      Hope the reply might have helped you.

      If the reply was helpful and replied your query, please mark it as "helpful answer" and close the question by marking it as "answered".