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
- 8602 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 is joiner transformation?
draw informatica architecture 8.6 ?
What does command task mean?
How you can differentiate between connected lookup and unconnected lookup?
Explain what transformation and how many are there in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Write the unconnected lookup syntax and how to return more than one column.
how to create user defined function (udf) in informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the maplet?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the different components of powercenter?
