0 / 0

Example data (DataStage®)

Last updated: Mar 12, 2025
Example data in the Change Apply stage of 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:

Table 1. 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:

Table 2. Change data set
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):

Table 3. After data set
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