Questions Ab Initio

There are many ways to create surrogate key but it depends on your business logic. Here you can try below ways. 1. next_in_sequence() function in your transform. 2. Assign key values component 3. Write a stored proc to this and call this stor proc wherever u need. 4. If you writing data into multi file then you have to use below formula to write numbers sequentially: (next_in_sequence()-1)*no_of_partition()+this_partition()