Reputation: 75
In ODI 12c I have file to table load. If I have correct data in file then data loaded into the table. If I have wrong data(eg for emp_name I have length 30 but in file I have length 40) then mapping is error out but .bad file and .error file is not created. Km used: file to sql
Please let me how to fix this issue
Upvotes: 1
Views: 1457
Reputation: 59
Error and log files will be getting created on the Work schema directory. Did you tried checking that directory or you can help me with the flow in operator so i can check and help you with detailed info.
Upvotes: 0