ora-01007 variable not in select list in informaticasince i have checked and verified the order of the column in the source qualifier port and the query. It is same, but then too returning the above error.
i tried of adding a date column "last_updated_by" from the table "per_absence_attendances" to the staging table "W_absence_event_ds"
i had three source tables for it per_absence_attendances per_absence_attendance_types per_abs_attendance_reasons Target(staging table) W_absence_event_ds
since its OOB mapping you should have 2 workflows(full and incr) for the same mapping, make sure your changes are affected to workflow ending with _Full.I dint copied the workflow SDE_ORA_AbsenceEvent_full to my custom folder. Whether is this the problem for this variable error whether can i copy the full(workflow) and can i try.
Can you let me know which (Full or Incr) workflow is running when you are testing this?i think SDE_ORA_AbsenceEvent workflow(Incr) is been running, since i can find this as i seen that workflow is been executing in workflow monitor while running DAC as it is failing.
Can you send me session log to my emailI have mailed U