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)
