during convert request i could see some records has been failed to convert. have used
trans ssn('=n SSN_NBR_FOR_CARD')
these three transformation.
how could i get the infomation. why the records has been failed to convert In the log file i could see the count of record that has been converted and filed to convert.
This topic has been locked.
1 reply Latest Post - 2013-03-27T13:53:45Z by SystemAdmin
Pinned topic How to get information why records are getting Failed to convert???
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-27T13:53:45Z at 2013-03-27T13:53:45Z by SystemAdmin
SystemAdmin 110000D4XK304 PostsACCEPTED ANSWER
Re: How to get information why records are getting Failed to convert???2013-03-27T13:53:45Z in response to SystemAdminHello,
Optim does not do a very good job of identifying everything you need to know to resolve the Convert errors that you are seeing.
Generally we ask the user to look at the Control File that was used and to take a look at the status column (to the left). Generally in this
case you will most likely see the status of 'XFM conversion error'. This is not immediately helpful for you, but what it
does do, is identify the 'row' where the problem occurred. Generally, you can look at the data and interpret what may have happened.
I hope this helps,