Do you run a Full Load or an Incremental Load ?
I think you run a Full Load and you have this issue (ORA-26002: Table DWH.W_STATUS_D has index defined upon it) because Informatica want to load data in a Bulk mode on this table. But you can load data in a Bulk mode only if there is no index on your table.
DAC deletes index, then loads data in a Bulk mode, then recreates index to finalize task.

Please see the status of your DAC task to see if index have been deleted. If it is the case maybe another index was created on the W_STATUS_D table but not declared on the DAC for this table.

are you able to navigate to the folder /d02/informatica/server/infa_shared/SrcFiles/ and see if the file SDE_ORAR1213_Adaptor.SDE_ORA_AbsenceEvent_Full.txt exist ?
I expect copying it - there is part of the installation/post installation tasks, did you miss that step maybe?

did you configure any of the codes manually as part of the csv file configuration? This error can occur if there is duplicate codes either in the source system or in a manually configured csv file. Run the SDE SQL directly and see if you are seeing duplicates. if helpful, pls mark