Need a help on Change Capture stage
Posted: Thu Mar 26, 2009 6:05 am
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?
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?