DSXchange

Hi Folks

I have a source like this

Empno,Ename,MGR
101,Tarun,vinay
102,vinay,Anand

i need output like this

Empno,Ename,MGR
101,Tarun,vinay,Anand
102,Vinay,Anand,Anand

using Transformer how to solve this.


Thanks

Would there be always be only two levels or it can be dynamic?

State your business / transformation requirements in words rather than making people puzzle them out based on simply posting input and output samples.

Classical solution should work. Self join!
Source -> Copy - > Two output link -> join -> Output.

And as usual the pitfalls in all the solution that is available for this problem statement persist like who is the manager of top executive, referential integrity setup.

When is the interview?

As noted, state the (full) requirement in words. This is called a specification, and may serve a useful mind-focussing exercise - you may even be able to come up with your own best solution.

Hi ray

finished.Interviewer asked me that scenario and i din't got how to solve that.

State the (full) requirement in words. This is called a specification, and may serve as a useful mind-focussing exercise - you may even be able to come up with your own best solution.