Interested to Buy Any Domain ? << Click Here >> for more details...
what is the look up transformation?
- 2 Answers
- 10048 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 |
What are the mapping parameters and mapping variables?
Tell me about informatica architecture.
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
why dimenstion tables are denormalized in nature ?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Parameter and variable differences
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
what is mapping override?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Teradata 
