SCD stage END_Dt column derivation

[edwds]

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.

[ray.wurlod]

Make sure that the date literal is of the correct format for your job.
Try surrounding your date with quote characters.

[nirdesh2]

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.

[edwds]

Thanks guys. It worked now. I was trying to assign the value to END_Dt column through a Job parameter and it doesn't work that way.

Thanks a lot.