Interested to Buy Any Domain ? << Click Here >> for more details...
what is the look up transformation?
- 2 Answers
- 9964 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 |
scd methodology?
why we r using presql&postsql in source qualifier?
What is meant by query override?
what is the size of u r project? and what is the size of source file?
What do think which one is the better joiner or look up?
what is the process we used in joiner transformation,there is no matching column in sources?
how to join the 2 different table with different columns in informatica?
replace multiple spaces with single space.
Define sessions in informatica etl?
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
How to delete the (flat file) data in the target table after loaded.
What are Business Components in Informatica?
Teradata 
