Forum Stats

  • 3,872,846 Users
  • 2,266,483 Discussions
  • 7,911,343 Comments

Discussions

ignore error during file to db load

User_F2HJQ
User_F2HJQ Member Posts: 162 Bronze Badge

Hi All,

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.