Dear all,
Two questions:
1. I could establish the Surogate key generation through flat file. Can you explain how to generate it through DB2 sequence.
2. I have a scenario:
Input : Dataset -- 2 million records contains (empname,esal)
In target DB2 table say EMP (empid is a sequence generator).
For every record in dataset, i want to capture the sequence number plus the value of employee in another dataset without inserting it into the target table..
so my target dataset should be (empid generated sequence no from table, empname, esal)
Can you explain me how to achieve this in parallel.. Thank you..
Surrogate Key -- Database Sequence
Moderators: chulett, rschirm, roy
Surrogate Key -- Database Sequence
Rockzz Tech
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's pretty obvious once you start playing with it.
There are three job designs that use the Surrogate Key Generator stage.
There are three job designs that use the Surrogate Key Generator stage.
- With no links, the Surrogate Key Generator stage creates a state file.
With an input link, the Surrogate Key Generator stage initializes a state file or obtains initial data from a database sequence.
With an output link, the Surrogate Key Generator stage delivers surrogate keys.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.