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
- 8455 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
can we override a native sql query within informatica? Where do we do it?
What is the difference between a connected look up and unconnected lookup?
What are the different clients of powercenter?
What all join we can perform in LOOKUP transformation?
What is workflow? What are the components of the workflow manager?
Scheduling properties,whats the default (sequential)
Explain the types of lookup transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
whats the logic to load the lower level of granularity of data to fact table.
Is it possible to define a single node as a Gateway node as well as worker node?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Is there any target staging area in informatica not staging area
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
what is the size of your data warehousing?
