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 a dimensional model?
How might one distinguish in the case of mapping is right or not without associating session?
what is the Default Source Option For Update Strategy Transformation?
Under what condition selecting sorted input in aggregator may fail the session?
Explain the different kinds of facts.
Explain transaction control transformation in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the new features of informatica 9.x at the developer level?
Design a mapping to load a target table with the following values from the above source?
where to store informatica rejected data? How to extract the informatica rejected data?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
In warehouses how many schemas are there?
what is diff b/t sorter t/r and agg have the option sorter property...
What is joiner transformation?
What are batches?
