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
- 8429 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
What is joiner transformation?
Is there any way to read the ms excel datas directly into informatica?
What is sequence generator transformation in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How can you generate reports in informatica?
what are the deliverables?in your project?
What is substr in informatica?
Can anyone tell me the new features in Informatica 9 Version?
What could be the possible resons of locks by user?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is sorter transformation?
What are the main issues while working with flat files as source and as targets ?
How to do the error handling of if ur source is flatfiles?
What is a joiner transformation and why it is an active one?
What is rank transformation in informatica
