how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 24016 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What are the different types of olap? Give an example?
what is the purpose of surrogate key and diff between primary key&surrogate key
How to do Integration testing in Informatica?
waht type of interface is used for testing the data in informatica
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What is repository manager?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
What are the databases that informatica can connect to windows?
Differnce between filter and router?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
Teradata 
