Sri

• Jul 28th, 2006

 

Hi Bava,

There r many ways to create Surrogatekey but it depends on your business logic. here u can try these ways...

1. use next_in_sequence() function in your transform.

2.use Assign key values component (if ur gde is higher than 1.10)

3.write a stored proc to this and call this stor proc wherever u need

...... Hope these stuff will help.

Bye Bava,

Sri

dontbuckme

 Profile Answers by dontbuckme 

• Sep 22nd, 2006

 

For #1, if the layout is not serial, you might need to do something like:

(next_in_sequence()-1)*no_of_partition()+this_partition()