Surrogate Key Generation In Datastage Parallel Job
An IBM InfoSphere DataStage job consists of individual stages linked together. Container can then be reused in different parallel jobs. You can also define a. Surrogate Key Generator, Sort, and Transformer Real Time includes stages such as Web Services Transformer, WebSphere MQ, and Web Services Client. Restructure includes stages. . USERS AFFECTED: The surrogate generator operator would not work in a DataStage Parallel job run under WISD. PROBLEM DESCRIPTION: Operators used in WISD jobs must be 'wave-aware' in order to correctly process the 'end of wave' indicator associated with the end of each transaction.
Answers were Sorted based on User's Feedback
Answer / venkatesh.m
by using the transformer we can do it.To generate seqnum
there is a formula by using the system variables
ie
[@partation num + (@inrow num -1) * @num partation
Answer / murali
yes ur right but we have another way to generate s key by
using transformer .in transformer we have a surrogate key tab
click the skey tab in that we hav state file and db sequence
these r used for generate and hold the s key value
Surrogate Key Generation In Datastage Parallel Job List
Answer / sudhir
Surrogatekey is nothing but a unique number to identify the
record in datamart. So just use a counter in StageVariable
of Transformer. Keep incrementing the counter by one for
every new inserts. This would form a surrogatekey.
Surrogate Key Generation In Datastage Parallel Job 2016
Answer / sreenu
Using the Routine
KeyMgtGetNextVal
KeyMgtGetNextValConn /frozen-throne-cd-key-generator-battlenet.html.
Answer / nish
sudhir your answer is wrong. /origin-games-key-generator-online.html. just incrementing will not work in a multinode config.
the answers that utilize the @partition num variable are correct
Surrogate Key Generation In Datastage Parallel Job Interview
Answer / snehasismacross frontier dubbed
By using system variable in transformer stage
like 1) create a stage var(SVK).
2) go to stage var. property type in the initial value tab as @partionnum - @numpartion+1
3) in the stage var. derivation type SVK+@numpartition