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

Using Source Qualifier -->double click Source Qualifier -->go to properties --> we have to write SQL Query (but our tables must available in same Database)

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.

Answer 2

You can achieve this when both the table belongs to same database and there should be some kind of PK, FK relationship. Use the sql override property in Source Qualifier Transformation to extract record from the source.