DSXchange

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.

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

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.

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.