Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 23517 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 |
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What are the types of metadata that stores in repository?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
what is the difference between Informatica 7.1 and Abinitio?
what is galaxy repository?
Enlist few areas or real-time situations where informatica is required.
what is normalizer transformation?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
What is mapping debugger?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
how can we load starting with 11th record of a table from source to target
Teradata 
