Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is mapping debugger?
What is the need of an ETL tool?
What you know about transaction control transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How can we improve session performance in aggregator transformation?
What are the popular informatica products?
how many types of dimensions are available in informatica?
State the differences between sql override and lookup override?
What is status code in informatica?
Reusable transformation and shortcut differences
Explain in detail scd type 2 through mapping.
What is the need for an etl tool?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the new features of informatica 9.x developer?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
