top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote

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 ?

posted Apr 4, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

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 Apr 7, 2014 by Shweta Singh
0 votes

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.

answer Nov 13, 2014 by Shatark Bajpai
Similar Questions
+1 vote

I have a source with multiple columns -
minA, maxA, minB, maxB, minC, maxC, minD, maxD

and I have 2 columns in target min values, max values. How can i put the min values of elements in min values of target and same with max?

+2 votes

How can we update a record in target table without using Update strategy?

+1 vote

Can anyone of you please elaborate on how to map the informatica for the inserts and updates to the target from source table?

I appreciate it, if you explain with example.