DSXchange

I am not able to load records into the UV table. The cause for rejections is stated as Mismatch in Data type in Log.

Intial design was directly loading the UV table from transformer.
Only certain records get rejected

But when tried using an intermedaite sequential file between the transformer and UV i was able to load the data without any rejections.

what could be the reason?

Thanks in advance

It's impossible to tell without knowing what the data types are and what data you are actually delivering.

You may be able to determine this by inspecting the warning messages in the log, or you can definitely see the data by tracing the Transformer stage.

The reason the intermediate text file works is that there are no real data types in text files, only text.