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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Why filter transformation is an active one?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the difference between a data warehouse and a data mart?
What are batches?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is incremental aggregation?
tell me about your project functionality
Enlist the various types of transformations.
Explain the different kinds of facts.
To import the flat file definition into the designer where should the flat file be placed?
What is an expression transformation in informatica?
What is enterprise data warehousing?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
