How to combine 2 columns from 2 database sources in Informatica Powercenter (9.1) -
i using informatica powercenter 9.1 , trying combine 2 columns 2 sources. trying create report show users , roles have on 2 separate databases. in 1 database , not other have account well. so if had output: database 1 (oracle) user 1 = role a user 2 = role b database 2 (sybase) user 1 = role c user 3 = role d i want output this: user 1 = role --- role c user 2 = role b --- n/a user 3 = n/a --- role d any in figuring out appreciated. you can joiner transformation link them , use expression concat. read database using 2 separate source qualifier transformation , join them using joiner. join condition user_id. join type should full outer join. full join pick data (matching , not-matching) in either table. then pickup user_id, role1(oracle) , role 2 (sybase) , concat them ifnull logic - iif (isnull(role1), 'n/a', role1)||iif (isnull(role2), 'n/a', role2)