Answer Posted / manjula

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

Please let me know how to make Data masking in informatica..

1270

---

What is data transformation manager process?

619

---

How many dimensions are there in informatica?

629

---

Write the advantages of partitioning a session?

745

---

Define mapplet?

627

---

---

explain abt ur project architecture?

1765

---

What are the mapping parameters and mapping variables?

624

---

Informatica settings are available in which file?

591

---

How can we create index after completion of load process?

600

---

What is a predefined event?

662

---

Mention a few design and development best practices for informatica?

563

---

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,

6756

---

What are the types of schemas we have in data warehouse.

531

---

What are the components of the workflow manager?

639

---

what is index?how it can work in informatica

1587

---