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
Define update strategy?
In development project what is the process to follow for an etl developer from day1
Differentiate between joiner and lookup transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is workflow monitor?
Explain the informatica workflow?
How to extract sap data using informatica? What is abap? What are idocs?
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?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain why we use partitioning the session in informatica?
How you can differentiate between connected lookup and unconnected lookup?
Can we create a Integration service without a Repository service and vice versa?
Difference between Target-based loading and constraint-based loading?
How do you change a non-reusable transformation to reusable transformation?
How to update source definition?
