Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 8607 Views
- IBM, I also Faced
- E-Mail Answers
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
How to handle decimal places while importing a flatfile into informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is joiner change?
What is the use of source qualifier?
design of staging area?
What is rank transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Suppose we do not group by on any ports of the aggregator what will be the output?
Can we create multiple integration service on single repository?
which one is better performance wise joiner or look up
What is an active transformation?
What is the scenario which compels informatica server to reject files?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the function of union transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
