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
Re: File having 12 records I have to send data to different targets
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.
Re: File having 12 records I have to send data to different targets
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
Re: File having 12 records I have to send data to different targets
[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
Re: File having 12 records I have to send data to different targets
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.