T) What is the logic generate the sequence number for each record of multi file?
(Next_in_sequence-1)*number_of_partitions+this_partition()
Posts
Showing posts with the label next_in_sequence
T) How to Create Surrogate Key using Ab Initio?
- Get link
- X
- Other Apps
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()