Answer Posted / shiva shankar naidu n

1.Join supports all types of joins, but lookup supports only
two types of joins supports like inner and left outer only..
2.join not provided rejected link, but lookup provided it.
3.join is high sorting speed but not lookup.
4.join takes huge amount of data from two tables, but look
up not supported to data than source table.
5.In lookup Reference data always less than source data
other wise its not suppoted.
6.lookup always based on condition, but not join stage.
7.join common column must be same, in look up no need common
column name.

Why do we need informatica?

925

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2688

---

What does update strategy mean, and what are the different option of it?

1034

---

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

964

---

What is target designer and target load order?

1050

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1198

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2040

---

can u give example for factless fact table

6440

---

What is persistent lookup cache?

965

---

what is mean by complex business rule ?

2108

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7071

---

In informatica workflow manager, how many repositories can be created?

1263

---

What is sq transformation?

1077

---

Performance tuning in UNIX for informatica mappings?

2505

---

What are roles and groups and benefits of using them?

988

---