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
- 8251 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kannan
Simple logic here,
1) SQ passes the records one by one(logical field values
eg . customer id) to lkp up t\f.
2) Then, with this logicl field values , it looks into the
database( source \target db,provided cache is disabled in
properties), fetched the records(only look up enabled
columns) and passed to the down transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
On which transformations you created partitions in your project?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to create the source and target database connections in server manager?
How can informatica be used for an organization?
Define joiner transformation?
In informatica workflow manager, how many repositories can be created?
How to convert multiple rows to single row (multiple columns) in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the features of complex mapping?
State the limitations where we cannot use joiner in the mapping pipeline?
What are junk dimensions?
What is the meaning of decode in informatica?
What is status code in informatica?
Why filter transformation is an active one?
