CDC problem with partion
Posted: Tue Sep 21, 2010 1:06 am
Hi,
In my job i am using CDC stage.I have to compare source data with target data if any new records then i should insert.I have desinged like this refence(less) Ref(less) target
! ! !(entire&sort on 4keycol)
source-Lookup- -----Loookp----(entire&sorton 4keycol)CDC---Trans(Surkey)---TargetDB
My source contains 2,000,000 records .if i run on 2node i am getting 4,000,000 records.and it taking 2 to 3 hr time.I should get only 2,00,000 records(new records only 2,000,000).Please help me if any solution for this one other than running on single node and perfomance tunning for this job.
Thanks
V....
In my job i am using CDC stage.I have to compare source data with target data if any new records then i should insert.I have desinged like this refence(less) Ref(less) target
! ! !(entire&sort on 4keycol)
source-Lookup- -----Loookp----(entire&sorton 4keycol)CDC---Trans(Surkey)---TargetDB
My source contains 2,000,000 records .if i run on 2node i am getting 4,000,000 records.and it taking 2 to 3 hr time.I should get only 2,00,000 records(new records only 2,000,000).Please help me if any solution for this one other than running on single node and perfomance tunning for this job.
Thanks
V....