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
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:-
Use Router transformation by giving different condition as per ur requirement for each target.
cheers
Last edited by Rksinghpathania; 06-28-2007 at 03:04 AM.
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.