How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

Question

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

Answer 1

Why are you wanting to avoid the joiner transformation?

Answer 2

You could join the two tables using sql in the source qualifier as long as both tables exist in the same database and the connection used can access both tables.