Interested to Buy Any Domain ? << Click Here >> for more details...
how lookup is acting as both active and passive ?
how is it possitble?
- 9 Answers
- 60835 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / priyanka
hi
Suppose if we have 3 records with same key value, only then
first, last are considered. Based on given preference, if
it is first, it will consider the record which comes first.
If it is last, it considers the matched record which comes
by the end of that session.If there are no duplicate
records then,if there is a matched record it will return
the respective data for that record else with return NULL.
But, as it tracks all the records with some result i.e
either with its value or NULL, we consider it as passive
transformation
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What do you mean by filter transformation?
How can you differentiate between powercenter and power map?
What is an aggregator transformation?
What is update strategy transform?
can u any challenge your project?
How to load a Dimension ? and how to load a fact table?
server hot-ws270 is connect to Repository B. What does it mean?
What is the commit type if you have a transaction control transformation in the mapping?
What are the tasks that can be performed using sq?
How to configure mapping in informatica?
How to do unit testing in informatica? How to load data in informatica ?
Mention few advantages of router transformation over filter transformation.
What are the types of caches in lookup? Explain them.
What is meant by lookup transformation? Explain the types of lookup transformation?
What is data movement mode in Informatica and difference between them?
