ERROR:ORA-02292: integrity constraint () violated - child record found in informatica

ERROR:ORA-02292: integrity constraint (FDS.SYS_C00740002) violated - child record found

Reason: you are trying to delete the parent record which is having the chaild record

solution:

execute the below query with the constraint name :

select * from all_constraints where constraint_name='constraint name'

ex:

 select * from all_constraints where constraint_name='SYS_C00740002'

you can find the table name in the result set.for that table you need to disable the constraint or if that table is not needed you can drop  the table.