Interested to Buy Any Domain ? << Click Here >> for more details...
how to join the 2 different table with different columns in
informatica?
- 5 Answers
- 23700 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Which are the different editions of informatica powercenter that are available?
How can repository reports be accessed without sql or other transformations?
what is the size of your data warehousing?
Is there any way to read the ms excel datas directly into informatica?
Explain scd type 3 through mapping.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Enlist few areas or real-time situations where informatica is required.
Explain load alternative records / rows into multiple targets - informatica
What is a router transformation?
what is the Default Source Option For Update Strategy Transformation?
What are roles and groups and benefits of using them?
Define Pmrep command?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How will the document be delivered to me?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
