Topic
  • 1 reply
  • Latest Post - ‏2013-03-27T13:53:45Z by SystemAdmin
SystemAdmin
SystemAdmin
304 Posts

Pinned topic How to get information why records are getting Failed to convert???

‏2013-03-27T05:54:39Z |
during convert request i could see some records has been failed to convert. have used
SHUFFLE(DEST=(BORROWER_NME),IGNORE=(BORROWER_NME(NULL,spaces,zero_len)))
SHUFFLE(DEST=(COMPANY_NME),IGNORE=(COMPANY_NME(NULL,spaces,zero_len)))
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.
Please help
Updated on 2013-03-27T13:53:45Z at 2013-03-27T13:53:45Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: How to get information why records are getting Failed to convert???

    ‏2013-03-27T13:53:45Z  
    Hello,

    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,
    Kevin