how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / vidyasagar
@Srinivas
after condition satisfies it does'nt reduces rows
say
src_table Lookup_table Result
10 10 10
20 Null
30 Null
number of sources=3 and result also 3 rows hence
Lookup is a passive transformation :)
Regards:
Vidyasagar
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
What are batches?
Difference between Data and Index Caches?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain in detail about scd type 1 through mapping.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is repository manager?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain the difference between a data warehouse and a data mart?
How do you load first and last records into target table?
What is the meaning of up gradation of repository?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Is it possible to define a single node as a Gateway node as well as worker node?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is a sequence generator transformation?
Explain the pipeline partition with real time example?