DSXchange

Thanks Priya..

I found a solution by getting the EFF_DT accepted as timestamp field and later on in the job i typecasted using TimestamptoDate funtion in the transfromer before inserting it into the target table.

I have the same problem,in Oracle the EFF_DT field has a DATE datatype.When i try to use in an Oracle Enterprise stage and supplying the below query SELECT to_char(PIP.EFF_DT,'YYYY-MM-DD') as START_DT FROM table it is giving the error Error when checking operator: When binding output interface field...

If someone has implemented a SCD 2 in DataStage using CDC Stage.It would be helpful if they could put a screenshot of the job.