Saturday, July 15, 2006

Informatica 7.1:Multiple Execute Error

Well,now I am getting interested in Informatica a lot.I got amazed by its huge power of running query and prompting result in a very short span of time.

This error came when I was trying to implementing a router having two groups in it.And I made mistake while using conditions for those groups.Actually the condition set in one group may fetch data for the other group also.

Let me describe in details:
Emp ( src )
--------------

Eno Sal
--- ---
1 2000
2 3000
4 7000
5 2500
6 3500
7 5500

Now for a group I set condition like Sal > 2000 and for the another Sal > 3000.
SO the first group in fact fetching the data for the other group also.Here in lies the error.

So once you rectify it as Sal > 2000 and for the another Sal < 2000 the problem will be solved.

Labels:

0 Comments:

Post a Comment

<< Home