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
- 8246 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 target load order?
How does the aggregator transformation handle null values?
How many dimensions are there in informatica?
What is the difference between a repository server and a powerhouse?
What is the advantage of informatica?
Under which circumstances, informatica server creates reject files?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
how to create user defined function (udf) in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain the pipeline partition with real time example?
Global and Local shortcuts. Advantages.
How to join three sources using joiner? Explain though mapping flow.
scenario where i can use only concurrent execution of workflow.
Explain the different kinds of facts.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
