DSXchange

Hi all,

I am getting this error,

XFM050: Error when checking operator: When binding input interface field "EFF_DT" to field "EFF_DT": No default type conversion from type "string" to type "date".

But i checked through out the job, EFF_DT is of type DATE.

any idea why i am getting this error.

Thanks
venkat

You have mapped a col defined as string (char or varchar) to a col defined as date. Check it in the transformer stage. You may need any conversion function.

Check the schema associated with EVERY link. Somewhere there's a string data type. Otherwise you wouldn't have seen that particular error.

Sainathan Is correct, thats the mistake in transform
You have mapped a col defined as string (char or varchar) to a col defined as date. Check it in the transformer stage.

Hi all,


I have solved the problem, I just renamed the EFF_DT as EFF_DT_1, it got compiled,

But i have check through out the job, EFF_DT is a Date type, no way it can map to the string datatype, I dont know why it shouted like that.

any have thanks for your reply pals.

Do you have RCP enabled, and there's a string EFF_DT in a source schema?