how to join the 2 different table with different columns in
informatica?
Answers were Sorted based on User's Feedback
Answer / reni
Create one dummy record for each table:
from 2 source qualifiers connect a expression
transformation to create a output port as "Dummy" & assign
the value "1" to that port.
Then in joiner join based on this dummy port of two
different source.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / krishna
By Handling on this we go for joiner tr make sure that there
is a common coloumn b/w the two tables.other wise not possible.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / balanri
Hi,
I will presume this question as generic one.
In general case when we are joining 2 tables, no need to
bother about field names of it.,joining field datatypes are
only factor needs to consider..
Hence, we have 2 possible ways in informatica for joining 2
tables:-
Join 1 :
Let say , S1, S2 => 2 source tables from same db conn.
string/server with same credentials.
T1 => target table.
S1,S2 => SQ1 => Exp1 => T1
Here, SQ1 sql will take care of joins as we code sql.
Join 2:-
In case if S1 and S2 are from two different environments or
db's.
S1,S2 => Joiner Transformation J1 => Exp1 => T1.
Joiner J1 is compatible to have all options for building
Join condition.
Thanks.
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / anoosha
by using joiner transforamation we can join or merge the
different columns from two different table at informatica....
eg:emp;customer or dept table tak d common fields by dat
join d 2tables....
| Is This Answer Correct ? | 2 Yes | 5 No |
in performance wise union is past,union all is past
What is union transformation in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
What are the reusable transformations?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
in a table it has 200 rows the query is select 150 from tablename.whats the output
If we set dd_insert in mapping and Delete in session properties what will happen.?
What are active transformations.
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
which quality process u can approach in ur project
What are the popular informatica products?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,