Home » Developer & Programmer » Warehouse Builder » OWB SCD1 surrogate ID, sequence is not followed for new records (OWB 10.2.0.3)
OWB SCD1 surrogate ID, sequence is not followed for new records [message #310816] Wed, 02 April 2008 08:40 Go to next message
snakedentist
Messages: 1
Registered: April 2008
Junior Member
When I implement SCD 1 in a mapping and I add a new record in the source and run the mapping again, the surrogate ID dosent follow in sequence.

example: 5 records in source after running the map, there are 5 records in target dimension. so ID ends at 5

I add 1 record in the source; now 6 records in source. I run the mapping, the new record will have ID 11 instead of 6.

How can I get the ID to be 6? Any solution?....
Re: OWB SCD1 surrogate ID, sequence is not followed for new records [message #316820 is a reply to message #310816] Mon, 28 April 2008 08:07 Go to previous message
shaik4orafaq
Messages: 1
Registered: April 2008
Location: India
Junior Member
Hi,

Use NOCACHE, ORDER options while creating sequence and try it out.

Regards,
Shaik.

Previous Topic: Data Mismatch
Next Topic: Connecting DB2
Goto Forum:
  


Current Time: Mon Sep 22 18:08:29 CDT 2014

Total time taken to generate the page: 0.20372 seconds