| 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?....
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
