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
- 8442 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
Quickly characterize reusable change?
How can we store previous session logs?
Design a mapping to load the cumulative sum of salaries of employees into target table?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the difference between a repository server and a powerhouse?
Performance tuning in UNIX for informatica mappings?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is mean by complex business rule ?
Explain sessions?
What are some examples of informatica etl programs?
What is the need of an ETL tool?
How does a sorter cache works?
