File having 12 records I have to send data to different targets

Plz give the answer. If a file having 12 records shown below. I have to send empno(1,2,3) send to one target, empno(null) send to 2nd target, empno(4,4,4) send to 3rd target, empno(5,5,5) send to 4th target.

empno
1
2
3
null
null
null
4
4
4
5
5

By using Router transformation of the informatica u can do this.
in router u can give these three condition and defined ur target in user defined output group.on the behalf of the condition the records will move to the target.

Try it will work fine:-


[B][COLOR="Red"] Use Router transformation by giving different condition as per ur requirement for each target.[/COLOR][/B]

cheers

[QUOTE=rasmi;13864]Plz give the answer. If a file having 12 records shown below. I have to send empno(1,2,3) send to one target, empno(null) send to 2nd target, empno(4,4,4) send to 3rd target, empno(5,5,5) send to 4th target.

empno
1
2
3
null
null
null
4
4
4
5
5[/QUOTE]
Try it will work fine:-

[B]Use Router transformation by giving different condition as per ur requirement for each target.[/B]

bye

Hello guys, just my two cents:

In informatica that is the best solution, the use of router transformation and setting different conditions. Otherwise, you can use or create a procedure that's decode's each condition ... which is a bit more tricky.