DSXchange

i have emp table like

empno
111
222
333

i have two target links

target link1
empno
111
222

target link2
empno
111
333

NOTE:without using switch AND filter stages

Can you explain your logic to decide which row goes into which target link? Your example is missing that information.

to link1
111
222

to link2
111
333

harikumar wrote:NOTE:without using switch AND filter stages

This smells like an interview question to me.

I believe strongly that interview answers should accurately reflect the interviewee's own knowledge and skills.

Your reply to Arnd's question was not what I'd call logic. We (you) need to know what are the rules for duplicating one (or more?) particular row but not others. Perhaps you could ask your interlocutor?

I can't think of a logical reverse-engineered logic for the selection with only 3 source rows to work with. I can think of several useless and unlikely formulae, including "the sum of each row and its predecessor must be even in Link1 and odd in Link2"...

This is simple use Transformer stage and map the columns to two output likns as how you need data in the output....

That's the big question, though, isn't it? Just how are rows allocated to the different outputs? harikmar remains strangely silent on this question.

harikumar wrote:to link1
111
222

to link2
111
333

As noted, this explains nothing and just parrots your earlier example. Please detail for us in words how you decide what goes where.

Otherwise the problem reduces to a brain-dead answer to the exact question. The two constraint expressions would be of the form: