DSXchange

Hi,

Can any help me to overcome this issue, what is execution order for

Before subroutine,after subroutine, job parameters, constraints, derivation,stage variables.

Hi All,

can any one please help me to solve the below query.

source:
empno, Sal
101,1000
101,2000
101,3000
102,1000
102,2000
102,3000

output:
empno,sal
101,1000
101,10002000
101,100020003000
102,1000
102,10002000
102,100020003000

Thanks In advance.

Hi Raja,

its working fine

Thank you somunch for your help..

Hi Ray,

will you please explain clearly....am not getting your point.

Hi can anyone plese help me on below

source table name A A B B B C C D In source table data like this but I want traget table like this name count A 1 A 2 B 1 B 2 B 3 C 1 C 2 D 1 pls any one one solve this........

Hi,

can any one please help me on, what is the difference between CREATE KEY CHANGE COLUMN and CREATE CLUSTER KEY CHANGE COLUMN in SORT stage.

Thanks in advance.