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 is incremental aggregation?
how many types of dimensions are available in informatica?
What is workflow? What are the components of the workflow manager?
What are the various types of transformation?
Explain transaction control transformation in informatica
What is lookup change?
What is a snowflake schema?
What do you mean by filter transformation?
What do you understand by term role-playing dimension?
Write the different tools in the workflow manager?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How many numbers of sessions can one group in batches?
Enlist the differences between database and data warehouse.
How many number of sessions can one group in batches?
How might you approve all mappings in the archive all the while?