transform map scripts for both group and group members:


find_real_file.png


find_real_file.png


while loading data from an AD for groups and group members



group member data is imported and after that, at time of transform it considers only first user


imported data :


u_member : CN=user name1,OU=Users,OU=AN,OU=User Accounts,DC=corp,DC=ACD,DC=com^CN=user name2,OU=Users,OU=Eur,OU=User Accounts,DC=corp,DC=ACD,DC=com^CN=user name3,OU=Users,OU=Australia,OU=User Accounts,DC=corp,DC=ACD,DC=com^CN=User name4OU=Users,OU=Australia,OU=User Accounts,DC=corp,DC=ACD,DC=com^CN=user name5,OU=Users,OU=Australia,OU=User Accounts,DC=corp,DC=ACD,DC=com


this is data loaded in import set table


when tranform has done then only user name1 is tranferred and user name 2, 3,4 and 5 are not stored in table



we are using a custom table to store group members - as this is our requirement



field map script:


find_real_file.png