| OWB SCD1 surrogate ID, sequence is not followed for new records [message #310816] |
Wed, 02 April 2008 08:40  |
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  |
shaik4orafaq
Messages: 1
Registered: April 2008
Location: India |
Junior Member |
|
|
Hi,
Use NOCACHE, ORDER options while creating sequence and try it out.
Regards,
Shaik.
|
|
|
]
Members
Search
Help
Register
Login
Home
