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 ?
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.
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.
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?
How can we update a record in target table without using Update strategy?
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.