Hi I have a before dataset with (1,2,3) records in it.
and After Dataset with (1,3) records in it.( 1 , 2, 3 --these are change key values)
Change mode - is Explicit key , all values.
In case of which record out of 1 , 2,3 the delete code will be generated....?
and if the target is the a oracle table from which the before Datset is created will it delete the before detaset record? if delete query is used?
Need a help on Change Capture stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
sagar,
You will get the delete rows and its corresponding delete code. Of course this depends upon the property value for "Drop output for delete".
The other field value is simillar to as it is in the Before link. Reason is, the delete record obviously will not be present in the After dataset.
Here in this case the number of fields in After dataset and the Before dataset should be same and it should have the same metadata too.
Now if you want only to delete these records from your target Oracle table, then put a constraint to pass only the records having the Delete code Or
only get the Delete code records from Change Capture stage.
Then use your delete query in the target stage.
Is this answers your question![Question :?:](./images/smilies/icon_question.gif)
You will get the delete rows and its corresponding delete code. Of course this depends upon the property value for "Drop output for delete".
The other field value is simillar to as it is in the Before link. Reason is, the delete record obviously will not be present in the After dataset.
Here in this case the number of fields in After dataset and the Before dataset should be same and it should have the same metadata too.
Now if you want only to delete these records from your target Oracle table, then put a constraint to pass only the records having the Delete code Or
only get the Delete code records from Change Capture stage.
Then use your delete query in the target stage.
Is this answers your question
![Question :?:](./images/smilies/icon_question.gif)
Ping me if I am wrong...
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai