How to solve this scenarios using Transformer

Prince_Hyd · Post by **Prince_Hyd** » Mon Jun 03, 2013 7:55 pm

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

rsomiset · Post by **rsomiset** » Mon Jun 03, 2013 8:52 pm

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

chulett · Post by **chulett** » Mon Jun 03, 2013 10:10 pm

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

prasannakumarkk · Post by **prasannakumarkk** » Mon Jun 03, 2013 11:19 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 04, 2013 12:46 am

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.

Prince_Hyd · Post by **Prince_Hyd** » Tue Jun 04, 2013 9:13 am

Hi ray

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

ray.wurlod · Post by **ray.wurlod** » Wed Jun 05, 2013 10:04 pm

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.