How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 29216 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define meta stage?
What is ibm datastage flow designer?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the benefits of datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How do you start developing a datastage project?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How complex jobs are implemented in datstage to improve performance?
What is a merge?
how to add a new records into source?
Explain entity, attribute and relationship in datastage?
Why do you need stage variables?
Have you used Unstructured data?
How to reverse the string using unix?
What are the job parameters?
