I am using a SCD stage and implementing Type II.
When I try to ASSIGN a Default Future date "2999-01-01" to END_DT column, I am getting the following error. Setting it to NULL works fine but I wanted a default future date. When I try to assign a date value through a Job parameter it does not work.
Invalid derivation for the SCD type 2 expired date column 'END_EFFCTV_DT' - the correct derivation should be either a literal or SetNull() function call.
SCD stage END_Dt column derivation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: SCD stage END_Dt column derivation
Just check the datatype of END_EFFCTV_DT whether it is date or Timestamp. If it is Timestamp then assign the value like '2099-12-12 00:00:00' . I am using in this way and it is working fine.
Nirdesh Kumar