what is the look up transformation?
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 |
why we r using presql&postsql in source qualifier?
What are the differences between oltp and olap?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
Parameter and variable differences
What is CDC? How to implement CDC?
What is source qualifier transformation in informatica?
What is the use of target designer?
what is mean by grouping of condition column in lookup transformation?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
How are the sources and targets definitions imported in informatica designer?