lookup is passive y can't it be active?
let us say i have some records in my source like
101,rohit,1000
101,rohit,1000
102,kumar,2000
like wise
now as it is having multiple matches i return only
first,last value it can't return bouth the values
that means lookup is acting as select distinct right by
default what means it is active?
Answer Posted / pune.rohitsharma
well my ans as we are doing look-up on source and we are
getting the records from the DB not from any other t/r
so that's y it is passive.
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What is decode in informatica?
Explain sessions and how many types of sessions are there?
What is the maplet?
What the difference is between a database, a data warehouse and a data mart?
Does an informatica transformation support only aggregate expressions?
What are the main issues while working with flat files as source and as targets ?
can we override a native sql query within informatica? How do we do it?
What is a filter transformation?
permutations of mapplet
What are active and passive transformations?
Is stop and abort are same in informatica?
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.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the new features of informatica 9.x in developer level?