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.

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

what is lookup ?

7 Answers  

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

How to load a Dimension ? and how to load a fact table?

0 Answers  

---

In Which scenario did u used Incremental loading?

2 Answers  

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---

what is data driven in informatica

5 Answers   IBM,

---

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---