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.

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7113

---

What is the procedure for creating independent data marts from informatica 7.1?

997

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1078

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

981

---

design of staging area?

1959

---

Enlist the various types of transformations.

950

---

How can you differentiate between powercenter and power map?

1017

---

What is a dimensional model?

926

---

Have you worked with/created Parameter file

1610

---

What do you mean by enterprise data warehousing?

1001

---

server hot-ws270 is connect to Repository B. What does it mean?

2437

---

Name the different lookup cache(s)?

1156

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5558

---

Define joiner transformation?

981

---

expain about the tune parameters?

2334

---