I am currently working on a scenario in Informatica Powercenter designer where the situation is as follows:

**SQ1:** I am pulling employee records according to the criteria of having a layer of employees based on their hierarchy (Client relation directors) which is the first source qualifier and in which i am doing a sql override to extract data from 3 tables, 
and for those selected employees I have to pull some other information for example: 

**SQ2:** what client relations they are handling which is in a separate source qualifier and

**SQ3** some of the personal information from their profile which is in a third source qualifier.

I have single mapping in which there are three source qualifiers as described above and in all of them I am using SQL override. My question is that the data that i have pulled in first qualifier brings a subset of the total employee records, but in Source qualifier 2 and source qualifier 3 I have to pull all employee data and then do a join on employee\_id in two joiners to finally collect data for the layer of employees that are coming from source qualifier 1. What i want is that if somehow I save the employee ids from and SQ1 and use them in SQ2 and SQ3 so that i pull data for only a subset of employees, the problem is I cant split the mapping and cannot add the code for selecting the subset from SQ1 bc it will be repitition of code and taking a long time to run, also the number of records are about one million. I cant find a way to perform the above that is why i am asking for help here.

I am pulling data from db2, and working in powercenter designer 9.5.1.
I will be thankful if i can get guidance regarding the above issue