Example data (DataStage®)
This example shows a before and change data set, and the data set that is output by the Change Apply stage.
This example shows a before and change data set, and the data set that is output by the Change Apply stage when it has compared them.
The following table contains the before data set:
| bcol0 | bcol1 | bcol2 | bcol3 | bcol4 |
|---|---|---|---|---|
| 0 | 0 | 0 | 0 | a |
| 1 | 7 | 1 | 1 | b |
| 2 | 2 | 2 | 2 | c |
| 3 | 3 | 3 | 3 | d |
| 4 | 5 | 4 | 4 | e |
| 5 | 2 | 5 | 5 | f |
| 6 | 6 | 6 | 6 | g |
| 7 | 7 | 7 | 7 | h |
| 8 | 8 | 8 | 8 | i |
| 9 | 9 | 9 | 9 | j |
The following table contains the change data set, as output by a Change Capture stage:
| bcol0 | bcol1 | bcol2 | bcol3 | bcol4 | change_code |
|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | b | 3 |
| 4 | 4 | 4 | 4 | e | 3 |
| 5 | 5 | 5 | 5 | f | 3 |
The following table contains the after data set, output by the Change Apply stage (bcol4 is the key column, bcol1 the value column):
| bcol0 | bcol1 | bcol2 | bcol3 | bcol4 |
|---|---|---|---|---|
| 0 | 0 | 0 | 0 | a |
| 1 | 1 | 1 | 1 | b |
| 2 | 2 | 2 | 2 | c |
| 3 | 3 | 3 | 3 | d |
| 4 | 4 | 4 | 4 | e |
| 5 | 5 | 5 | 5 | f |
| 6 | 6 | 6 | 6 | g |
| 7 | 7 | 7 | 7 | h |
| 8 | 8 | 8 | 8 | i |
| 9 | 9 | 9 | 9 | j |