what is the look up transformation?
- 2 Answers
- 10099 Views
- Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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)
| Is This Answer Correct ? | 7 Yes | 2 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
without dynamic lookup transformation how to insert new rows and update existing rows?
how many data models u have done in informatica project?
How will the document be delivered to me?
how to identify new and old values in source qualifier or any other transformations using informatica
how to obtain performance data for individual transformations.
Can we use the mapping parameters or variables created in one mapping into another mapping?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
how can we run workflow with pmcmd?
What are the different ways to implement parallel processing in informatica?
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 ?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
Teradata 
