Record Formation
Posted: Fri Jun 29, 2012 12:07 pm
Hi All,
Can someone please tell me how do I accomplish the following in datastage 8.1 version.
incoming record:
colA COLB ColD
1 2 3
expected output:
COL E:
1
2
3
incoming record:
colA COLB ColD
1 1 1
expected output:
COL E:
1
incoming record:
colA COLB ColD
1 1 2
expected output:
COL E:
1
2
incoming record:
colA COLB ColD
2 1 1
expected output:
COL E:
2
1
incoming record:
colA COLB ColD
1 2 1
expected output:
COL E:
1
2
Thanks
Pavan
Can someone please tell me how do I accomplish the following in datastage 8.1 version.
incoming record:
colA COLB ColD
1 2 3
expected output:
COL E:
1
2
3
incoming record:
colA COLB ColD
1 1 1
expected output:
COL E:
1
incoming record:
colA COLB ColD
1 1 2
expected output:
COL E:
1
2
incoming record:
colA COLB ColD
2 1 1
expected output:
COL E:
2
1
incoming record:
colA COLB ColD
1 2 1
expected output:
COL E:
1
2
Thanks
Pavan