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.

What does cheating measurement mean?

1105

---

What is deployment group?

1293

---

What are the different components of powercenter?

1109

---

What is parallel processing in informatica?

1787

---

what is the size of your data warehousing?

2140

---

how we can load rejected record's at run time?(not through bad files)

2422

---

Why do you use Mapping Parameter and mapping variable?

1805

---

What is aggregate cache in aggregator transformation?

1197

---

Slowly changing dimensions, types and where will you use them

1767

---

What is aggregator transformation in informatica?

1000

---

What is blocking transformation?

1185

---

wat are deployement groups in informatica, how it will be used for developers

1770

---

What are the types of presistent cache in look up tr.

2104

---

difference between informatica 8.1.1 and 8.6

3728

---

How will the document be delivered to me?

1126

---