DSXchange

Hi,

I got the following error when i wrote a constraint in Transformer stage:

"Error in constraint expression for link DSLink5. Invalid conversion requested from a timestamp to a int64".

Its a parallel job. The constraint is: eff_dt<term_dt<rnst_dt Or (eff_dt<=term_dt And last_dt<=term_dt).

Can, u please help me out with it.

Thanks,

Hi,

Create 3 Stage Variables with Integer Datatype and convert your eff_dt, term_dt and last_dt into Julian Days using the JulianDayFromDate conversion function. Store the values in the 3 stage variables.

Use the Stage Variables in your constraint.