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.

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2191

---

How we can create indexes after completing the load process?

1164

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2308

---

What are the issues you have faced in your project? How did you overcome those issues?

2366

---

What are the different clients of powercenter?

1067

---

What is the difference between source qualifier transformations source filter to filter transformation?

1060

---

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

1067

---

Explain about Informatica server process that how it works relates to mapping variables?

1089

---

Differences between version 7.x and 8.x.

1900

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2187

---

What is transformation?

1107

---

Why union transformation is an active transformation?

1051

---

How can we use mapping variables in informatica?

1068

---

What is different between the data warehouse and data mart?

1074

---

Explain how to import oracle sequence into informatica?

1022

---