DSXchange

I know there are similar posts ,but pl have a look at this one. these are 50 warngings PT_RPOS_Lookup.LdLookup: ds_uvput() - Write failed for record id '92612921' PT_RPOS_Lookup.LdLookup: ds_uvput() - Write failed for record id '92453581' and the below is the message after Attempting to Cleanup afte...

Hi roy,
my db is oracle9.2,my source is flat file(which comes once in a week) and this job runs once in a week.creating new partitions is not an option.here how to update only one column in target.

thanks

i need to fix the target table.source is flat file and there are several couple of lookup(hash) files..now i correct the job and it's working fine for the past two weeks.but here my concern is how to fix the previous data which is around 189 mil records..

we have a fact table with 200 mil recs, my previous developer develop a job to load this table by using wrong hash file as lookup(so one column in these 200 mil rows is wrong ).now i have the correct hash file too..but how can i update those 200 mil recs with correct data.