Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30982 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 13 Yes | 0 No |
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
| Is This Answer Correct ? | 5 Yes | 0 No |
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.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sreenu
Using the Routine
KeyMgtGetNextVal
KeyMgtGetNextValConn
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nish
sudhir your answer is wrong. just incrementing will not work in a multinode config.
the answers that utilize the @partition num variable are correct
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / snehasis
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
| Is This Answer Correct ? | 1 Yes | 2 No |
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
How to convert alpha Numeric values to alpha using functions?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
how to capture rejected data by using join stage not for lookup stage. please let me know
How do you register plug-ins?
What are the types of containers?
what is the use of DSattchJob?DetachJob? where can we find it?
what is the unix script to run the job? Please mention commands which we use often?
how to handle null values using transformer stage?
when we will use connected Lookup & Unconnected Lookup
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
How do you import and export data into datastage?
Teradata 
