how lookup is acting as both active and passive ?
how is it possitble?
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
When do you use sql override in a lookup transformation?
what is size of u r database?
How to Create a folder using pmrep command?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Why filter transformation is an active one?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain the different kinds of facts.
Mention few power centre client applications with their basic purpose?
How to use pmcmd utility command?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
if we have a delimiters at unwanted places in a flat file how can we over come those.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to create a non-reusable instance of reusable transformations?
Mention few advantages of router transformation over filter transformation.
pmscmd startworkflow -sv