Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30813 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 |
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
What are the processing stages?
What is apt_config in datastage?
plz tell me some dimentional and fact table names in banking project?
What are operators in datastage?
Please tell me What is difference between 8.0 and 8.1
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
how can you generate sequence number using only the sequential file stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the differentiate between data file and descriptor file?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
Teradata 
