Interested to Buy Any Domain ? << Click Here >> for more details...
what is the look up transformation?
- 2 Answers
- 9973 Views
- Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / swetha
Use lookup transformation in u'r mapping to lookup data in a
relational table, view, synonym.
Informatica server queries the look up table based on the
lookup ports in the transformation. It compares the lookup
transformation port values to lookup table column values
based on the look up condition.
| Is This Answer Correct ? | 1 Yes | 1 No |
In how many ways we can create ports?
what is curr val use for in sequence generator?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Using Expression transformation how to remove duplicate records from a relational source?
What are the parts of Informatica Server?
what is inline view?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
In which scenario did you used pushdown optimization?
How can we use batches?
Plz can any one say me how to get the informatica certification materials and dumps
How do you convert single row from source into three rows into target?
How many joins in Informatica
Teradata 
