DSXchange

Sorry for the late reply Craig,Yes I did try with vertical result but I am not getting the expected result,from vertical pivot I am getting value like below. Col1 Col2_val1 Col2_val2 Col2_val3......... A 10 110 120 .......... B 20 210 220 ......... also Pivot index has a restriction of Array size 10...

I have below src as my input
COL1 COL2
A 10
B 20
C 30
D 40
A 110
B 210
C 310
D 410
A 120
B 220
C 320
D 420

I want result like below in tgt

A B C D
10 20 30 40
110 210 310 410
120 220 320 420

Its an example of src data,in actual src for COL1 A,B,C and D are repeated for more then 100 times.

Thanks Chulett and Yugee for your quick help.Resolved.

Thanks Chulett for those links provided.I see in those links mainly discussed how to create dynamic flat file .In my requirement there will be only two target flat files How to distribute records among the target files as I asked above?

Target is flat file.

Hi All, Can any one help me achieving below scenario. Input: No Name 1 ABC 2 ABC 3 ABC 4 ABC 5 ABC 6 ABC 7 ABC 8 ABC 9 ABC 10 ABC 11 ABC 12 ABC 13 ABC 14 ABC 15 ABC 16 ABC 17 ABC 18 ABC 19 ABC 20 ABC 21 ABC 22 ABC 23 ABC 24 ABC Target:1 No Name 1 ABC 2 ABC 3 ABC 4 ABC 5 ABC 6 ABC 7 ABC 8 ABC 9 ABC 1...

ray.wurlod wrote:Welcome aboard. The optimized job score will remove a Copy stage that does a simple transfer, so the two jobs will have identical performance. You can prevent this removal via the Force option in th ...

Thanks Ray for warm welcome.

Why to use copy stage if there is only single input and output? Case1 :If we are using copy stage from seq file(src) to seq file(tgt) and doing nothing simply sending src records to tgt . Case2 :If we are directly sending src records to tgt without using copy stage. Which case has the better perform...