DataStage - how can we generate a surrogate key in server/parallel jobs?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 255 of 390

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

Total Answers and Comments: 4

Last Update: July 04, 2009 Asked by: praveen

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 12, 2006 10:18:22

Ram

RE: how can we generate a surrogate key in server/para...

In parallel jobs we can use surrogatekey generator stage.

Is this answer useful? Yes | No

October 28, 2006 09:26:40

trinity

RE: how can we generate a surrogate key in server/para...

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

Is this answer useful? Yes | No

November 02, 2006 07:33:42

Kiran

RE: how can we generate a surrogate key in server/para...

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

Is this answer useful? Yes | No

July 03, 2009 06:36:17

neeraj82

Member Since: July 2009 Contribution: 2

RE: how can we generate a surrogate key in server/parallel jobs?

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank