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
When do you use sql override in a lookup transformation?
Informatica settings are available in which file?
How to update a particular record in target with out running whole workflow?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Is it possible to revert a global repository to local one and why?
What is the need of an ETL tool?
What are some examples of informatica etl programs?
Why update strategy and union transformations are active? Explain with examples.
What are the transformations that are not supported in mapplet?
What are the different types of olap? Give an example?
Repository user profiles
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the use of target designer?
In development project what is the process to follow for an etl developer from day1
Define filter transformation?