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.

Under what condition selecting sorted input in aggregator may fail the session?

1087

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1013

---

What is DR strategy for Informatica project?

1137

---

What is the use of an aggregator cache file?

1157

---

What are the components of workflow manager?

1044

---

How to elaborate powercenter integration service?

1094

---

What are the limitations of joiner transformation?

1074

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1934

---

What is status code in informatica?

980

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2323

---

State the limitations where we cannot use joiner in the mapping pipeline?

1020

---

How to implement security measures using repository manager?

1120

---

What is xml source qualifier transformation in informatica?

1191

---

What is decode in informatica?

1100

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4063

---