How can we generate a surrogate key in server/parallel jobs?

  • Interview Candidate
  • 7
  • 4816

Showing Answers 1 - 7 of 7 Answers

Ram

  • Oct 12th, 2006
 

In parallel jobs we can use surrogatekey generator stage.

  Was this answer useful?  Yes

trinity

  • Oct 28th, 2006
 

HI,

in server jobs we can use an inbuilt routine called KeyMgtGetNextValue.

  Was this answer useful?  Yes

Kiran

  • Nov 2nd, 2006
 

You can also generate the surrogate key in the database using the sequence generator.

  Was this answer useful?  Yes

neeraj82

  • Jul 3rd, 2009
 

You can generate through system variable in transformer which is built-in name is keymgt. You don't have remember full name and in parallel you can generate through surrogate key generator.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions