Answer Posted / jaimeen shah

it is not possible to actually join two tables without
using any condition.
if U would like to join two tables, then in source
qualifier transformation add all the port from two tables (
if both tables are from same database source) and write
down your join condition in user defined join option or
otherwise write down join condition inside the sql query
option with generated sql query.

if u use two different database source then use joiner to
join the two tables.

Suppose we do not group by on any ports of the aggregator what will be the output?

1096

---

Briefly define reusable transformation?

1179

---

Is stop and abort are same in informatica?

1042

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1216

---

What are the different types of transformation available in informatica.

1144

---

What is the use of transformation?

1051

---

What is powercenter on grid?

1223

---

Enlist the various types of transformations.

1118

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10726

---

What are the types of schemas we have in data warehouse and what are the difference between them?

985

---

What are batches?

1184

---

what is size of u r database?

2362

---

Can you generate sequence numbers without using the sequence generator transformation?

1156

---

What is the Process to creating lookup transformation in informatica

1088

---

How can you differentiate between powercenter and power map?

1138

---