Answer / ashis

Add to sweta's answer:

We use lookup transformation to lookup data from a
relational table, view, synonym or flatfile against another
or the same table, view, synonym or flatfile.

This is mainly(not only)used for SCD's. So that the value
in the source can be compared with the existing target.

Lookup transformation are of different types named and
unnamed.

Mostly used lookup transformation types are Connected lookup
(Persistent Lookup, Dynamic lookup, Cached lookup, Uncached
lookup)

Answer / swetha

Use lookup transformation in u'r mapping to lookup data in a
relational table, view, synonym.

Informatica server queries the look up table based on the
lookup ports in the transformation. It compares the lookup
transformation port values to lookup table column values
based on the look up condition.

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---

Can you copy the session to a different folder or repository?

1 Answers  

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

What is meant by active and passive transformation?

0 Answers  

---

---

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---