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 377

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

Total Answers and Comments: 3

Last Update: November 02, 2006 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...

HI,

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