I am trying to load a file into target but the import is failing. The error thrown is as below;
During the import of leads into CRMoD through loading the New lead/Step lead file received from CA, leads have not been imported and we encountered the following
"Import field 'LAST_NAME' had a blank value for the required Oracle CRM On Demand field 'Last Name'. This record was not imported. Please enter desired values for
the required fields and re-import this record."
Leads are not imported due to an additional new line (Enter) character, which results in the subsequent lines not being picked up and the error of import failure.
Please help me to resolve this to remove the new line charactor in the field so that import succeeds..
By the way, I am working on ODI 11g.
While i was reading your post i remembered an issue that madded me. I don't know Oracle CRM, but a possible workaround could be to create a temporary Oracle table and load all data inside it. After that load in CRM only valid rows.