- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ignore error during file to db load
We have a requirement in our project for file to DB interface , while loading from source table to target table.
From source table in one of the field we are getting ||| as column separatore instead of || for one of the column , so it is throwing end be greater than begin error. When i run the interface it is getting errored out, but we dont want the execution to be stopped at that point.
We want execution to be continued and interface should not insert errored records which does not satisfy the format and it should insert all other proper records.
I have used incremental update and i enabled flow control and static control options but stil It is erroring out.
could you please provide any suggestion on how to ignore the errors.