Multiple choice technology web technology

How to Create Surrogate Key using Ab Initio?

  1. Using lookup() function

  2. Using Generate Records component

  3. Using re_index() function

  4. Using next_in_sequence() function
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

next_in_sequence() is the Ab Initio function designed specifically for generating surrogate keys by producing sequential, unique integer values. The lookup() function retrieves data, Generate Records is a component, and re_index() is for reindexing.

Keep practicing — related questions