DSXchange

if the id is same for several records,then the phone numbers will concatenate. how to do it with transformer or without using transformer source id,name,phone 1,abcd,7687656543 1,abcd,9876342123 2,bmp,6545365342 2,bmp,6575434566 3,xyz,9087878765 target id,name,phone 1,abcd,7687656543,9876342123 2,bm...

in surrogate key gen... i generate sid and
in filter where clause i gave the condition like
sid%2=0.
i send all remaining records to rejectlink.

stuartjvnorton wrote:Why not just use a filter?

i can use filter or transformer by giving contraint like
DSLink5.sno =1 Then DSLink5.sno Else 0

.but what if i hav large amount of data?

my data is like this deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage.i tried with seq--->surrogate key gen--->filter--->datastet and one reject dataset can anyone plz suggest ...

i hav data like this
1
1
2
2
2
3
how to send all 1's to one target,all 2's to other target and all 3's to another target.
can i use partition tech?