You are not logged in.
ok, I tried your suggestion and it works well.
According to what you said in the post,
update may have no results because no keys are matched in the table
Why don't you use tMap to inner join these two tables and update them by using tOracleOutput?
Do u have an example of tOracleSCD component? I'm confused with its description.
My problem is update may have no results because no keys are matched in the table. In this case I want to report an error to end-user.
You have been able to use tOracleSCD to get reject rows.
But recently a bug of tOracleSCD occurs in TOS 5.0 and 5.1.
You may have a try.
I'm using tOracleOutput component to insert/update data for a table. Do we have a component to retrieve the execution results? I want to know the successful records for insert/update and detailed information in case of failure.